Here's another possibility:

declare @t1 table (Id int)

insert into @t1 (Id)

select 1 union

select 2 union

select 3

declare @t2 table (Id int, X int)

insert into @t2 (Id, X)

select 1, 10 union

select...

justforgroups2004 (11/5/2012)

---

Hi Everybody 🙂

We ship books - no more than 10 books per box. And Other items (toys, etc.) – no more than 15 pounds per box. Books are...

What I would recommend is that you get your package working with a simple design and then just add the rest of the features and refinements one by one, testing...

Seems like you are maybe not the first to experience this. Have a look here and maybe you'll find some clues.

Was an eval version ever installed on this server?

OK, I doubled up on the slashes within the path, and put four slashes at the beginning to indicate the UNC path. My expression evaluates to this.

\\johnson\clientFTP\users\UBM\ATOM\GEN_V2_DAT_ENT_IUXA9_PRE_20121101_888888.txt

I set the connection...

SQLCrazyCertified (11/1/2012)

---

SSIS package jobs are failing in DEV/IST due to the following error.

Please let me know if you could help.

Error: 2012-10-31 01:00:14.73

Code: 0xC0000033

Source:...

cmcc (11/1/2012)

---

🙁

Didn't work.

Getting this

...is too long. Maximum length is 128.

I use a view for the data, which is short enough.

It's getting the column names output that is causing me...

dwain.c (10/31/2012)

---

Try removing...

Not that I've tried, but it looks like this will work:

1) Create a File System Task.

2) Change Operation to 'Create directory'

3) Change Use Directory If Exists to true.

4) Set the...

A very simple Script Task could check whether the folder exists and if not, create it.

Then do your file copy.

Pink123 (10/31/2012)

---

I have an SSIS job running in production.The job failed today with an error message

Executed as user: Test\SQLService. t" property not set correctly, parameters not set correctly, or connection...

Just add the CASE construct to your SELECT. The CASE construct can be made more compact too:

select distinct VacancyInternalID

,VacancyTitle

,null ParentInternalID

,null GeoLocation

,

order = (

case @SortFieldIndexConfig

when 2

then VacancyTitle

else VacancyInternalID

end

)

from Vacancy.TB_Vacancy va

inner join...

Recompile the script using the Script Component Editor?

Elliott Berkihiser (10/29/2012)

---

Re: "OpenQuery does not accept variables" --

This runs fine in my set-up:

Select * from OpenQuery(MyLinkedServer,'Declare @name varchar(50) Set @name=''RemoteDB'' Select * from sys.databases where name=@name')

Note the declaration...

harri.reddy (10/25/2012)

---

my file is like this

TH*4.2*857463*01**20091015*1045*P**~~IS*7564*ORACLE~

i have two table

table : TH

ID TH1 TH2 TH3 ...