Forum Replies Created
Viewing 15 posts - 136 through 150 (of 162 total)
-
RE: Looping Through Excel files and worksheets
Do all of the worksheets in all of the spreadsheets have the same column headings?
Tom
Life: it twists and turns like a twisty turny thing
-
RE: Securing a Report Builder Model
I don't think this is posted in the right forum.
Tom
Life: it twists and turns like a twisty turny thing
-
RE: OnError Event Handler
Do a search on the interweb for SSIS event handlers and you will find all sorts of comments about how and when the events fire.
Possibly one way to get around...
Life: it twists and turns like a twisty turny thing
-
RE: Update Record
Currently, there is no inbuilt update functionality within SSIS 2005 (I think there is something coming in SSIS 2008 to deal with this).
The only way is to write the new...
Life: it twists and turns like a twisty turny thing
-
RE: ftp task in SSIS
When you build your variable that holds the ftp path (or indeed, any directory path for that matter) you need to escape special characters of which "/" is one.
Simply replace...
Life: it twists and turns like a twisty turny thing
-
RE: SSIS Package - Exception Handling
I think in each case you could add a derived column called FLAG, or something like, which holds the information about each row whether it is VALID, INVALID or MISSING,...
Life: it twists and turns like a twisty turny thing
-
RE: How to produce an OLE DB output with no data input, only variables
I would have thought a SQL task would have been the best candidate for what you are looking to do. What were the errors you were receiving?
Could you not...
Life: it twists and turns like a twisty turny thing
-
RE: Dynamically connect to AS400 DB2 database through ODBC
Not sure if this will work, but you can set the whole connection string to the ODBC in one go, so you could build it dynamically with dsn name, username,...
Life: it twists and turns like a twisty turny thing
-
RE: Error on Excel import
A couple of questions:
Does the account that is running the package have sufficient priviledges on the excel file?
If so, have you tried saving a copy and accessing the copy?
Tom
Life: it twists and turns like a twisty turny thing
-
RE: making integer null in script component
I'm not sure I quite follow exactly what it is you need to do, but the derived column transformation allows you to change column values (or add in new columns)...
Life: it twists and turns like a twisty turny thing
-
RE: EXecute Process Task
Could you not use a data flow task with the excel file as the source and the csv file as the destination? It would be easier to debug where...
Life: it twists and turns like a twisty turny thing
-
RE: ssis 2005
Are the file locations hard coded into the package? If so, I think you can use a script task to access the connections programmatically, and from there pull the...
Life: it twists and turns like a twisty turny thing
-
RE: ODBC Password
Please excuse me if I am stating the obvious, but are the ODBCs set up on the target server?
Tom
Life: it twists and turns like a twisty turny thing
-
RE: How to use SSIS Config file with multiple connectionstring and how to pick the connectiong string depeding upon input value
You could store each connection string in its own variable (SQLDev, SQLProd, etc). Have a variable to hold the user's choice of environment (SetEnv, maybe). Then, have a...
Life: it twists and turns like a twisty turny thing
Viewing 15 posts - 136 through 150 (of 162 total)