Viewing 15 posts - 12,826 through 12,840 (of 13,876 total)
The last part of the error message actually states that the step succeeded too - it's just that there was an error in it.
Can you post the code for the...
May 11, 2009 at 6:06 pm
CozyRoc & Ramesh - great work, thanks for the help.
May 11, 2009 at 9:39 am
Ramesh (5/11/2009)
Here is that script:
Imports System
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Public Class ScriptMain...
May 11, 2009 at 9:16 am
CozyRoc (5/11/2009)
What is the issue when you try to use script component?
OK, I did this in a test environment to check. I have an OLEDB Source which just does a...
May 11, 2009 at 9:12 am
Thanks for the idea - tried it and:
The function REPLACE does not support the data type "DT_TEXT" for parameter number 1. The type of the parameter could not be explicitly...
May 11, 2009 at 8:14 am
Sorting a 10GB text file? I can imagine some complaints from the server ....
May 11, 2009 at 6:57 am
You should try the XML source adaptor in SSIS and see whether that can do it for you (it does not work for all XML variants).
If you are looking for...
May 11, 2009 at 6:46 am
- Create an int variable, scoped at package level, to hold the rowcount results.
- Use an Execute SQL task to run the count query and assign the result to rowcount
-...
May 9, 2009 at 1:40 am
Your sample data contains no commas, so each row will be interpreted as a single field.
May 7, 2009 at 6:19 pm
Maybe you could write to a single variable within the loop - just keep on appending messages to it as you iterate round - and then use the contents of...
May 7, 2009 at 10:11 am
Sure. Make sure that the variables you are using are scoped at the package level and then add your tasks to create the file and send the e-mail after the...
May 7, 2009 at 12:52 am
That's a real pain!
I think that you might have to import every row as a single text string and then use code (ie a Script component) to split the items...
May 7, 2009 at 12:30 am
There are loads of examples on the Internet. This one is nice and detailed and will help you get started:
http://www.codebeach.com/tutorials/sql-server-integration-services-your-first-script-component.asp
This one generates multiple output rows from a single input:
Phil
May 6, 2009 at 12:05 am
Maybe this article gives you what you need:
http://www.sqlservercentral.com/articles/Integration+Services/61542/
May 5, 2009 at 9:23 pm
Viewing 15 posts - 12,826 through 12,840 (of 13,876 total)