You are passing a string, not a set of integers.

Instead, I would try using table valued parameters.

Passing table valued parameters in SQL Server 2008

SQLPadawan (5/21/2014)

---

Forgive me, Jedi Master!

I disputed you. I didn't believe you could create more than SSISDB on a single operating system, BECAUSE if you look at the Feature Selection step...

Which provider did you select while trying to create the connection manager?

sunny.tjk (5/21/2014)

---

I already have SQL Server component installed in the location "C:\Program Files\Microsoft SQL Server\" but I'm curious to know if there is a way to change the default path...

1) and 2) You need to copy the config file yourself to the desired directory on the destination server.

3) In the SQL Server Agent jobstep you can specify additional XML...

It seems there are carriage returns in your data.

Simply add the following to your stored procedure:

REPLACE(Address,CHAR(13)+CHAR(10),'')

How about Microsoft SQL Server 2012 Internals?

Get ready though, that ain't an easy book.

nonghead-webspam (5/21/2014)

---

Ok, I went back to the ACE provider and things are working.

Turns out the problem was that the "Latest_File" variable needs an initial "feeder" value that will be replaced...

Nice one, thanks.

It's the first one you need.

If you run SQL Server set-up, is client tools connectivity installed?

Maybe you can try a repair?

SQL is delicious (5/21/2014)

---

Koen Verbeeck (5/20/2014)

---

SQL is delicious (5/1/2014)

---

brad.mccollum (5/1/2014)

To give you a little more insight as to the general nature of the SSIS package, it will basically be looping...

GouravSaxena1987 (5/21/2014)

---

Hello,

You need to check two things:

1. Wheter SSAS server is installed or not. for this please open SSMS --> Click on Conect in top left of Object explorer and...

I don't think this is possible with SSRS.

Jeff Moden (5/21/2014)

---

Koen Verbeeck (5/20/2014)

---

Jeff Moden (5/20/2014)

---

I'll be the first to admit that I don't know much about SSIS...

Out of the box it is not possible.

But maybe you can hack your way in with javascript.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/d0bb5af6-ca4f-4b67-a0f0-2e2ea297e98c/increase-tooltip-display-time?forum=sqlreportingservices