I\'m having a problem transitioning a 2005 package to 2008 - it appears that in 2008, package variables configured to use a Configuration Filter (eg populate from [SSIS Configurations]) will not honor
I was able to debug SSIS Script Task but then something happened to my PC that doesn\'t allow me to do this anymore.I\'m hoping someone on this forum can help me as I\'m about ready to send it to tech
I\'m getting this (Dts is not declared) exception when I try to build my SSIS script task. Any idea how to resolve it?
I have two excel source on one excel file 1st fetching value date and 2nd fetching value price now i have tried merge then union all also to get those two values in one derived column
The problem When I try to save a file over ~1.5 MiB with EPPlus ExcelPackage.Save() throws a System.IO.IsolatedStorage.IsolatedStorageException.
I\'m working on a package in SSIS 2008 b开发者_StackOverflow社区ut I made a mistake and saved it.
So I have two servers. SER1, SER2. SER1 is the one from where I am supposed to copy the data and put it in SER2.
I have created ssis package that is taking data from excel file and insert data into table I have one Excel Source and Ole db connection
I might be blind, but I don\'t see how to CREATE the script component. I\'m not asking why do an asynchronous, how 开发者_运维技巧to work with it, etc. I just want to know how to add it to my package,
We have a new SQL 2008 R2 instance that\'s part of a cluster (active/passive) on Windows 2008.I\'m testing an SSIS package on the SQL instance that calls many child packages.It\'s been dying on random