November 6, 2008 at 9:14 pm
Hi all,
I need to convert the date in text format to date format. There is no problem for me to wirte program to do conversion such as "if January 1, 2005 then date= 01/01/2005" in the logic of the script task. However, my question is how to wire up the source and then pass the date out to destination? Source is MS Access, destination is SQL Server. How the Script task see the incomming date value from source since script task is outside data flow task (i.e. outside source/transformation/destination). Also, after the processing, how to pass the date variable out?
Howard.
November 7, 2008 at 5:13 am
Want a quick and dirty way of getting an SSIS package for your Access db to SQL Server?
Go into your "Dev" environment on SSMS. Rightclick a database and choose All Tasks -> Import Data. Choose to import from an Access db and follow the steps all the way to the end.
Wait! Don't disregard this. It actually works... Instead of RUNNING the Import, Save it as a package. Then open up the package in your BIDS Solution and alter as needed.
I don't know why MS doesn't have an OCDB or Access Data Source in SSIS, or why they don't give you the option of building your own Access to SQL import process, but they obviously have the capability or you wouldn't be able to use the Import / Export Wizard to do such a thing.
Anyway, cheat by using the Wizard, it'll build most of the components for you, then open in BIDS and fix up as necessary. That should work for you.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply