Viewing 15 posts - 1,966 through 1,980 (of 1,988 total)
Okay thanks for the information, I guess I'll have to change our backup plan a little to accomodate it.
June 28, 2011 at 3:03 pm
To clarify are you saying you have two rows in your data flow with an int and a string and you want to export them to a csv? That...
June 28, 2011 at 1:42 pm
I tried explaining what I do to someone who is not computer savvy and i got compared to a librarian... sigh. Now I just say I work with computers.
June 24, 2011 at 10:50 am
Having a different version of SQL server in your dev environment than in your production environment is kind of asking for trouble, which you seem to have found.
I'm not familiar...
June 15, 2011 at 2:17 pm
Well if the people modifying your database are changing column names/data types or deleting columns then you would need to update your SSIS package wherever that column is referenced. ...
June 13, 2011 at 6:45 pm
Well to figure out what your server is doing you'll need to look at the jobs configured in SQL agent and find out which packages they're running. Like the...
May 18, 2011 at 5:47 pm
Craig Farrell (4/28/2011)
ZZartin (4/28/2011)
Have you tried using a derived column in the data flow to replace the columns you're getting bad data in with cleaned data?
While not a bad idea,...
April 28, 2011 at 5:44 pm
Have you tried using a derived column in the data flow to replace the columns you're getting bad data in with cleaned data?
April 28, 2011 at 5:39 pm
You could also potentially use a script component to keep track of the number of rows you're processing and code it so that it opens a new file every X...
April 19, 2011 at 3:24 pm
This sounds like something you could do with variables and package configuration. You might be able to use a script task to set the variables in your parent package...
April 12, 2011 at 11:51 am
Yes I've used it before when i needed to push data to an odbc connection, it's not quite as fast or convenient as an OLE DB destination but it works....
April 7, 2011 at 5:53 pm
Ah okay that makes sense. You can use a Script Component as a destination in the dataflow to write the information you need to an ODBC destination. Basically...
April 7, 2011 at 5:30 pm
Well any information you can get from a SQL query you can get through an OLE DB connection in SSIS assuming you have an account with access to run the...
April 7, 2011 at 3:03 pm
You could monitor it in SQL Server Profiler and filter the results down to just updates on your CO table. That should give you an idea of what users...
March 28, 2011 at 6:35 pm
As i recall size would be used to decrease the size of the database file to reclaim unused space, not increase the size of the file. As long as...
March 28, 2011 at 6:30 pm
Viewing 15 posts - 1,966 through 1,980 (of 1,988 total)