Post reply

SSIS Is Not Just for SQL Server

  • July 8, 2008 at 4:10 am

    #839340

    This makes sense once you think about it. SSIS is written using the .NET Framework so all "Strings" in any .NET language are treated as Unicode (WSTR). It is always a pain for me to get things into a DB as just STR (i.e. VarChar).

  • December 24, 2008 at 2:05 am

    #917270

    Hi,

    I have a string variable which is of scope package and a .dtsconfig file which contains the value of the variable. I am using this variable in Execute process task as an argument using Evaluate expression. My question is how can I assign the variable value in dtsconfig file to variable in Package?

    Please help me in this.

    Thanks in advance.

  • December 24, 2008 at 6:44 am

    #917354

    Without going into too much detail, using configuration files in this manner is one of the basics and you can probably find a lot of help online or in the help files. Basically, go to Package Configurations, enable Configurations, and choose an Xml file for your config file. The Wizard kind of walks you through everything and helps you map you Config settings to your Variables.

    http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply