Viewing 15 posts - 16 through 30 (of 212 total)
You need to use the Conditional Split in a Data Flow Task.
Use the Lookup to determine if a record already exists.
November 18, 2009 at 6:43 am
Right-click on your XML Source and select Show Advanced Editor.
Go to the Input and Output Properties tab.
Expand your output and it's Output Columns folder.
Click on the SubCategoryID field and change...
November 17, 2009 at 1:33 pm
The 2 little squares don't always signify a carriage return/line feed. They could be any non-printable character.
Your best bet is to open the file in a text editor that...
November 17, 2009 at 1:01 pm
Try adding the Flat File Source back to the Toolbox manually.
Open a Data Flow task.
Right-click in the Toolbox & select Choose Items.
Go to the SSIS Data Flow Items tab.
Check Flat...
November 16, 2009 at 10:28 am
Right-click on your XML Source and select Show Advanced Editor.
Go to the Input and Output Properties tab.
Select the Description output and set the IsSorted property to True. Expand the...
November 11, 2009 at 12:53 pm
Have you tried adding an XML Source to a Data Flow?
If you don't have the .xsd, the XML Source can create one for you. The XML Source will generate...
November 11, 2009 at 12:04 pm
Or, instead of creating a table and still using a derived column transformation while assuming the file extension is still 3 characters in length, this will work:
SUBSTRING(@[User::FileName],LEN(@[User::FileName]) - 11,8)
November 11, 2009 at 8:18 am
You don't need to use linked servers in SSIS. Set up a proper connection manager for the actual server.
November 3, 2009 at 7:21 am
You could add a Derived Column transformation that tests each of the conditions in your Conditional Split individually. Make each of the derived columns of type DT_BOOL.
Your first...
November 2, 2009 at 11:00 am
Yes, it's possible.
Use a Conditional to test the value of your column. If it = "abc", then you'll need to use a combination of a Type Cast and a...
October 30, 2009 at 1:42 pm
Is it possible that you have package configs set up so that when the package runs on your server it uses a different source/destination then when you run the package...
October 27, 2009 at 11:34 am
Can you edit the Excel template, changing the format of the column to Date with a locale of English (United Kingdom)?
October 26, 2009 at 9:12 am
Add an Active X Script task to the end of your Failure flow that simply sets the execution result to Success.
October 23, 2009 at 7:18 am
Search Help for "debugging [Integration Services], packages" or look up how to set breakpoints and use the immediate window while debugging.
October 22, 2009 at 3:02 pm
Viewing 15 posts - 16 through 30 (of 212 total)