Thursday, January 11, 2007 9:14 AM
I have a DTS package. I read in a DateTime value from my database which I use to select the records to be transferred via a Transfom Data Task.
However the millisecond component of the DateTime is not stored. I need to store the exact DateTime including the millisecond component.
Does anyone know a way around this problem?
Thursday, January 11, 2007 9:19 AM
From where you are calling the data from VB Script or SQL Script Task.. need more info
Thursday, January 11, 2007 9:44 AM
Sorry I'm an SQL begginer.
I have a DTS pacakage I created in SQL Enterprise Manager.
The first step in the pacakge ia an Execute SQL Task.
The SQL code is a simple : SELECT [DateTime] FROM table1
This returns one DateTime value.
Column is of Data Type : datetime, length: 8
I store this DateTime in a Gloabl Variable.
I then use the value in the next step to step the records to import from another database.
What I am attempting to do is this:
In another database a record is stored with a DateTime value.
The first time I run this DTS package I want to import all the records.
The next time I only want to import the new records - I was going to use the DateTime value to select which records to import.
The problem is though that the millisecond component of the DateTime value is not stored.
The SELECT [DateTime] FROM table1 statement returns the value 2006-11-30 08:58:49.273
But when I use the global variable its value is 2006-11-30 08:58:49
- it has lost the millisecond component causing records already transferred to be transferred again.
Thursday, January 11, 2007 9:52 AM
If you want simple solution then you can use the following query to store the datevalue into global variable..
SELECTConvert(Varchar,[DateTime],121) as [DateTime] FROM table1
Thursday, January 11, 2007 9:58 AM
That works perfectly and is really simple.
Thanks a million for you help!