I am importing tables from an Excel 2007 file to a SQL 2005 db using SSIS on a x64 Vista machine. I've noticed a significant slowdown (Window freeze, long execution time ) in SSIS package execution when importing data from Excel/Access 2007. Is it normal? I know Microsoft Visual Studio 2005 is not...

I have an encrypted file, which I need to import into a table in my database. This file consists of the full ANSI character set, including non-printing characters. Unfortunately SSIS tries to interpret these characters by using the built-in character sets. I would like SSIS import to not interpret non...

what is the diffrence in DBMS and RDBMS?

If you are using standard logins to connect to SQL Server these items are lost when you save and deploy the package. You need to change the settings for the package security level. This can be done on the Properties for the package under Security | ProtectionLevel. One option is to use DontSaveSenstive...

It was a great article. How do I deploy to a test server though? Do I need to create the SSISConfig database in the test server? What do I need to do to get the values into the test server? Sorry, but I am very new to this. I saw examples for deploying using XML files, but not for SQL Server package...

This post is related to this tip: SSIS: Perfmon Counters for the Data Flow Engine http://www.mssqltips.com/tip.asp?tip=1390