I'm with you, Jeff. Using the threat of leaving, directly or indirectly, as a means to increase your salary feels ethically wrong and akin to bribery. If you're leaving, leave,...

Not at all. Devenv.com can be used...

nick.latocha (9/16/2015)

---

Thanks Phil. No issue really - I'm working on getting files in the SVN.

All our packages are run via dtexc on a dedicated server - so trying to...

Please expand the sample data query which I provided, to illustrate...

nick.latocha (9/16/2015)

---

In Visual Studio (BIDS) after you build your project you end up with two dtsx files. One in the solution root and one in the bin folder. Does anyone...

Here's some setup SQL for anyone who wants to try this.

Hint: please do this in future when you submit forum questions 🙂

if object_id('tempdb..#tab1', 'U') is not null

drop table...

Pulivarthi Sasidhar (9/16/2015)

---

Hello All,

I have an SSIS package, which loading 5 data files of same format into Single Destination Table by taking 3-4 Hours...

Now my Manager asked me to change...

And the ordering of the data is purely by date/time?

toni 667 (9/16/2015)

---

Hello,

I have following problem and I hope someone could help:

I have a table with a datetime and an Item column.

I want to retrieve only the rows where...

I can't see how. Gives this

Here's one way:

with rows

as ( select * ,

...

Try this.

select column1 ,

stuff(column1, charindex('@param1', column1),

charindex('@param2', column1)...

I use stored procs with parameters all the time, but not with DB2. Is...

Have you considered implementing this as a standard data flow, with your DB2 query as source and the CSV file as destination? It would seem much easier, though maybe I...

How is D:\jj\JJ_Data_Extract_20150914103322732.csv related to what you are doing?