Viewing 15 posts - 12,046 through 12,060 (of 13,849 total)
apache626 (5/17/2010)
Yes if it came in as a string filled with the number of spaces to match the fixed width for the field that would be fine. Thanks Phil
I...
May 17, 2010 at 8:22 am
If your script task is doing everything, it must 'know' what the field lengths should be - how else could it write a fixed-width file?
If the field came in as...
May 15, 2010 at 2:31 am
sql2k8 (5/13/2010)
when the data gets loaded . the excel will be kept in a file share. then the users will upload the...
May 14, 2010 at 12:38 am
dg227 (5/13/2010)
May 13, 2010 at 8:37 am
I don't know what's happening, that works for me. Anyone else got any ideas?
May 13, 2010 at 8:12 am
Kari Suresh (5/13/2010)
I given just like sourceTable in the ReadWrite variables list for the script task.And I used MsgBox to know the value like:
MsgBox(Dts.Variables("sourceTable").Value.ToString())
Replace "sourceTable" with "User::sourceTable" in your script...
May 13, 2010 at 7:30 am
domiemutai (5/13/2010)
May 13, 2010 at 7:22 am
Kari Suresh (5/13/2010)
Yes, it is package level variable. But it is resetting to old value i.e.: "SE_DatabaseServer".
Sorry, maybe I should have taken more notice of the subject of the thread...
May 13, 2010 at 7:15 am
Should work as you hope. What is the scope of your variable? It should be 'Package'.
May 13, 2010 at 6:30 am
How do you envisage a user initiating this job? Is it their own spreadsheet or one held centrally?
I'm assuming that your question is not just: "Can SSIS import data from...
May 12, 2010 at 2:03 pm
Use an Aggregate transform. T-SQL is faster though.
May 12, 2010 at 9:21 am
That's quite unpleasant.
You will need to read in the source data as a single string (no column delimiter) and then use a Script Component to parse & reformat the data...
May 12, 2010 at 9:01 am
Please post this in the BI forum - this is not SSIS related, as far as I can see.
May 12, 2010 at 7:20 am
"...spaces in the flat file itself..." I do not understand exactly what you mean. You did not answer my question about 'End of Shift'. Please provide accurate sample data.
May 12, 2010 at 4:44 am
Viewing 15 posts - 12,046 through 12,060 (of 13,849 total)