Viewing 15 posts - 12,286 through 12,300 (of 13,849 total)
Elliott W (2/4/2010)
In files specify:sqlserver_????????.xls
It could pickup sqlserver_AAAAAAAA because ? is not specific to numbers.. But this is about the only way I can think of..
CEWII
Expanding on this idea,...
February 4, 2010 at 1:08 pm
I just tried it and it worked as I suggested.
Against the properties for your flat file source, have you got 'retain nulls' set to true?
February 4, 2010 at 1:04 pm
Something else is happening here.
If I import the record
Affinity,,CT
into a database, I can guarantee that field number 2 would not somehow become a space in my database table. Do you...
February 4, 2010 at 12:42 pm
Sounds like a good solution to me.
February 4, 2010 at 9:43 am
dndaughtery (2/4/2010)
February 4, 2010 at 9:34 am
You use the word 'retain' in your original post. If a value is null in a database column and you export it to a text file, the way of retaining...
February 4, 2010 at 9:26 am
,, in a text file is the equivalent of NULL in a database table.
February 4, 2010 at 8:12 am
PATINDEX is not a valid function in SSIS expressions.
Maybe adding an additional condition would help:
&& FINDSTRING(Email,"@",1) < (LEN(Email)) - FINDSTRING(REVERSE(Email),".",1))
February 4, 2010 at 7:51 am
emily-1119612 (2/2/2010)
One approach would be to import all the data a table with 9 columns ...
Wouldn't this fail at the import stage, because SSIS would validate the number of fields...
February 4, 2010 at 6:58 am
Please show an actual example of the data in your flat file which shows how 'blank' and 'null' differ.
February 4, 2010 at 6:45 am
Can you use a T-SQL query for your source data? COALESCE would do the work for you very nicely.
February 2, 2010 at 6:32 am
I do not have the experience to argue either way - just thought I'd raise it as a point to be considered.
You would not use the Script Task to do...
February 1, 2010 at 2:34 am
wschampheleer (2/1/2010)
Write the output to a temporary file (eg RAW).
Add a second...
February 1, 2010 at 1:12 am
SSIS Guy (1/30/2010)
Check DTS xChange. It will not convert your DTS logic to SSIS but also adds many best practies for SSIS.http://www.pragmaticworks.com/Products/Business-Intelligence/DTSxChange/
Do you work for this company?
January 30, 2010 at 10:36 am
Viewing 15 posts - 12,286 through 12,300 (of 13,849 total)