Environment: SQL Server 2005
SSIS Visual studio 2005
I'm trying to set up a task to take two separate fields from a flat file source (one is a date and one is a time) and combine them into one datetime field on SQL Server.
flat file:
Pick_Dt
Pick_Tm
combine them into one field named:
Pick_TS...
PHV is correct--use a program. DLL calls are not supported from VBscript (unfortunately).
Even Microsoft states in the only site help for vbScript that DLL calls are beyond the scope of vbScript.
I have heard of people being able to do it, but it requires a great deal of coding. Therefore...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.