I have an SSIS package that sends mails for each record within a Foreach Loop Container.After the e-mail is sent, I add some text to a variable (within a Script Task) saying \"Mail sent to customer1@d
I need to set the Folder in my Foreach loop to a variable location.I tried just adding the location to my package configuration, and it acted like it worked, but when I opened the configuration file,
I have a file that contains a header record in the 1st row, and I need to evaluate only that one row. The rest of the rows 开发者_StackOverfloware detail records. I have it set up now as a flat file s
currently i have a package which contains a Script task. Inside we are calling one Stored Procedure and based on the result set we are setting some values to package variables.
I have a SQL Server 2005 SSIS package with an Execute SQL task. I edit the SQL statement, go through the OKs to make the change. I go back in to the Execute SQL task- and the changes have taken hold.
Hallo All, I have a little Problem with the SubString-Function in SSIS (Derived Column). So on.. That are the possible Input Strings:
Can someone please translate this into English? The primary reference \"Microsoft.SQLServer.ManagedDTS, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=MSIL
For the first time ever, I have created a custom Data flow component that will simply convert any string in UpperCase. I was very excited to find my custom component workin开发者_如何转开发g but has b
Currently I have an SSIS job that runs to move data from one sql 20008 machine to another. The job moves about 2 million records from about 6 tables. That takes about 5-10 minutes depending on the ser
I started learning Data Mining with SQL Server and I was curious that SQL Server Integration Services is capable to perform Term Extraction from English text. However I\'m interested to perform Text M
加载中,请稍侯......