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

I think he needs more than coffee - in fact, I think he had more than coffee ... And plenty of the stuFf too.

But, in the morning, he'll look...

Rather than saying "it's not working", which is close to useless to us, please provide details of what you tried...

ChrisM@Work (8/17/2012)

---

Phil Parkin (8/17/2012)

---

Missing something, I'm afraid.

SELECT ... INTO

always creates a new table. When it creates that table, uses the data types of the source columns, but not primary...

Nice work - thanks for posting back.

May I suggest that you consider using table aliases - it will make your query much more readable. Eg

select t.col1, t.col2 from tablewithaverylongnameindeedohyes t

--rather...

Missing something, I'm afraid.

SELECT ... INTO

always creates a new table. When it creates that table, uses the data types of the source columns, but not primary keys or identity...