Wrox Programmer Forums
|
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 12th, 2010, 08:12 AM
Registered User
 
Join Date: May 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Question DTS ERROR

Hi Everyone

I have little problem designing a dts package. Scenario is this ,I receive 54 text files in different timings daily so that we have to import data from a directory every one hour where another application done in unix creates text files. So we have a package to be executed every one hour goes check in that directory if new text file came then import that file into sql server.The files are named like NAME01YYYY-MM-DD.txt.So in DTS package I have 54 braches(dynamicpropertiestask-->Text(source)-->TransformDataTask-->ConnectionProperties) to read & pump text files data into sqlserver DB. Now the requirement is I have to design one more branch for new text file (i.e., 55 text file).

In dynamic property task how to set global variables for Connections,Text File (Source),OLEDBProperties,Data Source,Properties,Value?
By seeing existing dynamic properties task I am unable to follow.
I set up a dts package with dynamicpropertiestask,globalvariables,execute sql task, transform data task.
DTS is running fine for the default saved text source file only. When I run dts and put in different text files unable to load.
I know this might enough information. please help me it is really urgent.





Similar Threads
Thread Thread Starter Forum Replies Last Post
DTS Error Flexa1 SQL Server DTS 1 May 7th, 2007 08:18 AM
DTS Error Amit Yenurkar ASP.NET 1.0 and 1.1 Basics 0 February 23rd, 2007 02:36 AM
DTS error mtullock SQL Server DTS 1 July 28th, 2004 08:38 AM
DTS Error mtullock SQL Server 2000 0 April 22nd, 2004 05:49 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.