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

rajeshpalo2003 78748 (8/20/2012)

---

Thanks for your reply.

My SSIS package is configured by job.so i want to execute that job through stored procedure and i am try to execute that job 5...

rajeshpalo2003 78748 (8/20/2012)

---

Hi,

How to execute a job and loop through it until you have 5 jobs running in parallel(same job name)

Is it possible to run same job...

kishoremania (8/17/2012)

---

Hi,

I am loading data from sql server to a flatfile (.csv format). One of the column will have values like

=HsGetValue("GPDetail","Scenario#Actual;Year#2012;Period#P07;View#YTD;Entity#G1G2_0609000;Value#<Entity Curr Total>;Account#G3G4_19270999;ICP#I_0695;Custom1#topC1;Custom2#topC2;Custom3#[None];Custom4#[None]")

When I am trying to load it, data...