Viewing 15 posts - 11,911 through 11,925 (of 13,427 total)
Yes it does. Give it a try and see how you get on.
January 13, 2010 at 1:42 am
In your example, there is no tab after char1, the 'code', yet the rest of the data has tabs delimiting the fields. So it's really not clear - it looks...
January 12, 2010 at 2:20 pm
susanaw007 (1/12/2010)
Thanks for the information. but i'm creating a package programmatically....
I don't see why that precludes the use of a query for the source, but I guess you have your...
January 12, 2010 at 4:04 am
Change your source from a table or view to a query and perform a CAST there ...
January 12, 2010 at 1:45 am
Welsh Corgi (1/11/2010)
I can't confirm that because the BO is out of town.
I have always been able to set standards for naming conventions and file formats but I...
January 11, 2010 at 1:11 pm
Why not just set a breakpoint or two and then run the package? You'll get into a full, interactive debugging session, much richer than writing out the odd result to...
January 11, 2010 at 1:00 pm
Use a combination of LEFT, CHARINDEX and SUBSTRING to split the field up.
January 11, 2010 at 12:56 pm
So all of the source files have the same number of columns and could be accommodated by string datatypes?
That is, you could read in all the data as col1, col2,...
January 11, 2010 at 1:53 am
Here's an example I got from MSDN which may help:
Dim arr As New ArrayList
arr.Add("D:\Tests\a.txt")
arr.Add("D:\Tests\b.txt")
Dts.Variables("User::Collection").Value = arr
Can you also confirm that your User::FileNames variable is of type 'Object'?
January 11, 2010 at 1:36 am
To perform updates use an OLEDB Command within your dataflow.
January 10, 2010 at 2:59 am
Can you confirm that if you fix up the header in the source file, everything runs OK?
If so, can you post some actual data - just the first couple of...
January 10, 2010 at 2:52 am
Bru Medishetty (1/9/2010)
Check if the last line has any additional data which does not align well with the rest of...
January 9, 2010 at 7:32 am
Or you can reverse the string and parse from the right - useful if there is a possibility of multiple '=' or ';' in your input strings.
REVERSE(SUBSTRING(REVERSE([Column 0]),2,FINDSTRING(REVERSE([Column 0]),"=",1) -...
January 8, 2010 at 11:56 pm
You can't easily parse that. I'd bring all the rows in to a single Varchar field and then use T-SQL to parse it.
If you want to exclude rows depending on...
January 8, 2010 at 11:22 pm
Viewing 15 posts - 11,911 through 11,925 (of 13,427 total)