Viewing 15 posts - 9,256 through 9,270 (of 11,678 total)
What source component are you using?
You can always use a Data Conversion component and cast the column explicitly to integer.
Remember, this component doesn't actually cast a column, it rather creates...
July 8, 2011 at 5:42 am
Great question, thanks. I learned something (on a Friday! :w00t:)
July 8, 2011 at 1:14 am
In the dataflow, you probably have a Flat File Source.
Open it and click on preview.
July 6, 2011 at 11:23 pm
Gift Peddie (7/6/2011)
I would not say suddenly because the package will not compile if that variable value is missing.
What are you doing with that variable? Probably something more than just...
July 6, 2011 at 11:21 pm
Gift Peddie (7/6/2011)
Vertigo44 (7/6/2011)
Gift Peddie (7/6/2011)
Vertigo44 (7/6/2011)
Thanks! I eventually got it to work by using "\"" + CHG_PATNUM + "\"" in the Derived Column expression box.
Funny you added a derived...
July 6, 2011 at 2:27 pm
Great question. Got compression confused with encryption, so I got it wrong.
July 5, 2011 at 11:53 pm
ZZartin (7/5/2011)
Not only is SSIS strongly typed it's also not at all proactive about cascading changes you make to column metadata through a dataflow.
Luckily, this will change in the next...
July 5, 2011 at 11:25 pm
I'm afraid not, SSIS is strongly typed about its metadata.
On a sidenote: isn't a dataflow with 50 flows a little too big? Can't it be split into smaller packages?
July 4, 2011 at 7:42 am
Are you sure you put the correct expression in the destination and that you've not accidentically switched the source and the destination around?
I don't really see an issue in the...
July 4, 2011 at 7:40 am
call.copse (7/4/2011)
I'm just impressed that some people thought it was France...
Mon dieu!
France did play an important role though, but more in helping in the fight against the UK.
July 4, 2011 at 2:51 am
So now you're importing from .csv instead of Sybase, correct?
Save the package in the Import/Export wizard and look at the SSIS package in BIDS.
Make sure everything is configured correctly. Open...
July 4, 2011 at 12:21 am
prashant labde (7/3/2011)
I have created a package and further wherever i suppose to deploy it on...
July 4, 2011 at 12:18 am
Check out the OLE DB Command component.
But I would advice against it, as it will fire a single statement/transaction for every row in your dataflow, resulting in serious performance loss.
In...
July 4, 2011 at 12:15 am
Viewing 15 posts - 9,256 through 9,270 (of 11,678 total)