Actually, my name is now 'Pro' 🙂

n79799 (8/22/2012)

---

If you really want to directly check for a config file's availability, you can have a script task at the beginning of you package, which checks for the file...

You appear to have written your entire question in the subject line, leaving the body of the question blank - but you are new, so please be aware in...

Karan_W (8/22/2012)

---

I have Sql server 2005 business intelligence development studio installed into my machine.I need to develop one SSIS package.

requirement is:

1: read the raw text or CSV file which doesn't...

Sorry, my first post was rubbish. Try this:

create table #temp...

--edit. Removed post.

ChrisM@Work (8/22/2012)

---

Cadavre (8/22/2012)

---

Phil Parkin (8/22/2012)

---

Maybe I jumped to the wrong conclusion - I didn't spend much time considering the question itself. I just liked the fact that you had used...

Lowell (8/19/2011)

---

here's a snippet based on Seans example, that gets all the tables in FK hierarchy order and generates the Truncates/delete commands for you, so you don't have to drop...

Maybe I...

kishoremania (8/22/2012)

---

Yes you are right. I am exporting from sqlserver to csv file.

I tried pipe as column delimiter. It's not working too.

Can you please try to test once with the...

Especially not that solution! :w00t:

You may also like to read about BIML - a modelling language that can be 'built' into an SSIS package from within BIDS Helper (which is free). We use it...

n79799 (8/21/2012)

---

Hi

I am new to this forum and would like to take a stab at this question.

With whatever info you have provided....

Please see first what SSIS is sending to your...

Evil Kraig F (8/20/2012)

---

That shouldn't be too hard, actually, you merely only map the columns you need in the OLEDB destination to the table(s) in question. However, of a...

Stamey (8/17/2012)

---

I have a package that uses a for-each loop to connect to a list of servers to transfer various pieces of data for DBA administration stuff from the servers...