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