SSIS Packages
-
Hi, I saved a data import task to a SSIS package in MSDB. SQL Server 2005. Now how can I access that again??? I want to make an automatic task to upload files from a folder to tables?? Dont we have something easy and useful like DTS in SQL server 2005??? :confused:
Keep DotNetting!! GeekFromIndia
-
Hi, I saved a data import task to a SSIS package in MSDB. SQL Server 2005. Now how can I access that again??? I want to make an automatic task to upload files from a folder to tables?? Dont we have something easy and useful like DTS in SQL server 2005??? :confused:
Keep DotNetting!! GeekFromIndia
I can understand your angst, I knew DTS, it worked well and it was fairly simple. But they (MS) have moved on and inflicted us with SSIS, there is no going back. Alternatively you can write your own ETL solution. This is what we did rather than use SSIS.
Never underestimate the power of human stupidity RAH
-
I can understand your angst, I knew DTS, it worked well and it was fairly simple. But they (MS) have moved on and inflicted us with SSIS, there is no going back. Alternatively you can write your own ETL solution. This is what we did rather than use SSIS.
Never underestimate the power of human stupidity RAH
You wrote your own ETL Solution????? :omg: could you give me a headstart on that..not sure if i could have thought of that ever...
Keep DotNetting!! GeekFromIndia