Browse by Tags

• dts
• script component
• SSIS FAQs

• Which data providers are supported in SSIS?

  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... Posted Nov 13 2008, 10:19 PM by Nayan Patel with | with 1 comment(s) Filed under: SSIS FAQs, SSIS

• How to migrate parameterized DTS packages to SSIS (i.e. Parameters passed using command line from SQL Server Job)?

  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... Posted Nov 13 2008, 10:16 PM by Nayan Patel with | with no comments Filed under: SSIS FAQs, SSIS, dts

• How can DTS xChange save time and money?

  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... Posted Nov 13 2008, 10:15 PM by Nayan Patel with | with no comments Filed under: SSIS FAQs, SSIS, dts

• Is there any 3rd party tool available in the market other than DTS xChange to help with DTS to SSIS migration?

  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... Posted Nov 13 2008, 10:14 PM by Nayan Patel with | with no comments Filed under: SSIS FAQs, SSIS, dts

• What are the advantages/disadvantages of storing SSIS packages to MSDB vs File System?

  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... Posted Nov 13 2008, 10:12 PM by Nayan Patel with | with no comments Filed under: SSIS FAQs, SSIS

• Why should I migrate DTS packages to SSIS (advantages of SSIS over DTS)?

  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... Posted Nov 13 2008, 10:10 PM by Nayan Patel with | with no comments Filed under: SSIS FAQs, SSIS

• What are the main differences in SQL Server 2005 SSIS and SQL Server 2008 SSIS?

  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... Posted Nov 13 2008, 10:08 PM by Nayan Patel with | with no comments Filed under: SSIS FAQs, SSIS

• How to read/write variable value from child/parent package in SSIS?

  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"... Posted Nov 13 2008, 10:06 PM by Nayan Patel with | with no comments Filed under: SSIS FAQs, SSIS

• How to make my SSIS connections dynamic so I can easily switch to different environment (e.g. Dev, QA, Prod ...)?

  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... Posted Nov 13 2008, 10:05 PM by Nayan Patel with | with no comments Filed under: SSIS FAQs, SSIS

• How to loop through files in a specified folder, load one by one and move to archive folder using SSIS?

  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... Posted Nov 13 2008, 09:40 PM by Nayan Patel with | with no comments Filed under: SSIS FAQs, script component, SSIS

• How to send HTML email in SSIS?

  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... Posted Nov 13 2008, 08:06 PM by Nayan Patel with | with no comments Filed under: SSIS FAQs, script component, SSIS