Need some help with DTS & Input parameters

[laker42]

I need some help with a DTS package I am trying to design. Here is what I want to do:

I have 4 dbase files that I want to load into corresponding SQL tables. The files do not contain a meaningful date. So I want to add a SnapShotDate to them. I want to be able to specify this SnapShotDate when I run the DTS package. I have not been able to figure out how to accomplish this. I have experimented with DDQs but I wasn't able to get it to work. I welcome any suggestions that you might have on how to get this to work.

Thanks,
John

 

[JayKusch]

What format are the 4 database files ... txt, excel, ???

Thanks

J. Kusch

 

[laker42]

They are dbase5 files. I can get them into SQL Server tables no problem. I need help with how to input the snapshot date into the SQL tables.

Thanks,
John

 

[tlbroadbent]

If I understand correctly, the SnapShotDate is a column in each of the tables and you want it filled with a date. Do you want to update the coulmn with the current date and time or a different value?

If you want to use the current datetime, then set the default value of the columns to GETDATE(). If another value is to be used, update the column to the value after inserting the rows from dbase.

Update tablename
Set SnapShotDate=@datevalue
Where SnapShotDate Is Null

Does this help? Or have I misunderstood the question and problem?

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.comcast.net/sql/sql_articles.htm