Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
Password Reminder
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Display Modes
  #1 (permalink)  
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.

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 01: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

All times are GMT -4. The time now is 12:01 PM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.