August 13, 2008 at 10:58 am
I'm a little new to SSIS/DTS and have a problem that I'm not sure how to approach.
Im pulling in data from a text file, using a data conversion to convert to unicode, and writing data to the DB.
All the fields are porting over nicely except for the 2 columns that I'm trying to force into a date format so it will actually go into the DB. Ive tried every form of DT_InsertEverydataTypeInvolvingDateHere. Someone suggested scripting it.
Now the issue is I have NO idea how to pass the data im converting to a script and back to the data convert, or if thats even how its done. Once I can pass it I can code it np just passing the string or column would really do the trick.
plz help?
August 14, 2008 at 7:09 am
If this doesn't help, can you post a little more detail? Jack Corbetts sig gives a link to a good guide to the type of info that's helpful
http://sqlblogcasts.com/blogs/jorg/default.aspx
hth
Andrew
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
August 14, 2008 at 9:49 am
andrew gothard (8/14/2008)
If this doesn't help, can you post a little more detail? Jack Corbetts sig gives a link to a good guide to the type of info that's helpfulhttp://sqlblogcasts.com/blogs/jorg/default.aspx
hth
Andrew
Nailed It! Thanks much
August 15, 2008 at 7:37 am
scottw (8/14/2008)
Nailed It! Thanks much
glad to help
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply