-
Data-Connectivity Providers and SSIS Note: The following is not a definitive list of all data providers, and not all data providers on this list have been tested by Microsoft with SSIS. Only current Beta or shipping products are listed. Information about...
-
Many times we get this question "How do we handle parameterized packages using DTS xChange?" Parameterized package means package executed from command line with parameters passed to it. Most common parameters are global variable initial value...
-
DTS xChnage is developed by a team of experienced developers/DBAs who have great experience with DTS to SSIS migration and they have migrated thousands of packages. So they understand the pain of migration process and they have already faced all challenges...
-
No - Only available option is DTS xChange or inbuilt MS DTS Migration Wizard But study suggests that MS Migration Wizard Success Rate is very low. DTS xChange has several enhancements and new features compared to MS DTS Migration Wizard which saves significant...
-
This is another common question we face many times "Should I store my SSIS Packages to File System or on SQL Server?" There are two places you can store your packages: on the file system or in the msdb database. Each storage option has its own...
-
We get this question almost every day so we ended up creating new FAQ for that "We can run DTS Packages in SQL Server 2005/2008 without any problem so what's the need to upgrade them to SSIS?" Well there are many good reasons why you should...
-
Here is the list of couple of major changes in SSIS 2008. New Script Environment: Script Task now supports VB.net and C# both languages. In the previous version of SSIS only VB.net support was there. Enhanced SQL Statements: Transact-SQL supports the...
-
Changing value of child package variable was easily possible in DTS using "Execute DTS Package Task" settings called inner/outer variables. But unfortunately this is not directly supported in SSIS if you using "Execute SSIS Package Task"...
-
In DTS if you want to make your connection attributes dynamic (i.e. Server, UserName, Password etc.) then you can use UDL files or Dynamic Properties Task but none of them were effective and they had their own drawbacks. In SSIS Microsoft came up with...
-
In DTS if you want to process files in a specified folder then you have to do good amount of work. But If you want to implement same in SSIS then you don't have to do much work. You can use "Foreach Loop Container" in SSIS to loop through...
-
SSIS Improved Send Mail Task by adding support of SMTP but still it lakes most common email requirement which is send email in HTML format. Send Mail Task in SSIS only support text format so again programmers have to use script task and write some VB...
-
Using ADO objects inside ActiveX Script task is very common in DTS. People use ADO objects (i.e. ADODB.Connection, ADODB.RecordSet etc) for many reasons but the most common use are Creating connections at runtime Executing Adhoc Queries at runtime Processing...
-
Generally developers use Scripting.FileSystem object in ActiveX script task to perform various file system related tasks (e.g. Copy file, Delete file etc.). In SSIS you can perform many file system related common tasks using File System task . You should...
-
If you have a flat file with quotes around the data as text qualifiers you may have seen the issue where the headers has the quotes even after you put the quote in as the text qualifier. This is a simple issue to resolve. If you check the box “Columns...
-
When mainframes or partners are uploading a file, you don't want to process the file until you're certain the file is fully uploaded. One way to do this is with a Script Task in SSIS. There is no magic property to determine in the operating system...