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...

Great question, thanks. I learned something (on a Friday! :w00t:)

Nice question, thanks.

In the dataflow, you probably have a Flat File Source.

Open it and click on preview.

What are you doing with that variable? Probably something more than just...

Gift Peddie (7/6/2011)

---

Vertigo44 (7/6/2011)

---

Gift Peddie (7/6/2011)

---

Funny you added a derived...

Nice question, thanks.

Great question. Got compression confused with encryption, so I got it wrong.

Luckily, this will change in the next...

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?

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...

Mon dieu!

France did play an important role though, but more in helping in the fight against the UK.

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...

prashant labde (7/3/2011)

---

Yes it possible as far as i know its possible to change connection related properties.

I have created a package and further wherever i suppose to deploy it on...

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...