guerillaunit (1/31/2012)

---

Hi,

I have a Visual Studio package that pulls data from an Access table and imports it into my SQL server. The database that the Access table resides in...

How is the package constructed? Do you use standard SSIS components, or do you also use a script task?

Your best chance right now is to add logging, as jpomfret7 suggested.

vardan.hakopian (1/31/2012)

---

Thank you guys all for for your responds.

I used Export Data to create SSIS pakage.I saved (file system) then created a Agent job.But job fails.Here is the error...

It's understandable. The solution is sometimes very well hidden.

Are you checking on the server or on your own machine?

The "For Dummies"-series is usually quite good for a quick introduction.

soniaj (1/31/2012)

---

Hello! Thanks for replying.

My Network Engg in the US has done it for me.

He has just provided me with the instance name saying that i am an Admin...

Anamika (1/31/2012)

---

Hi,

I'm going to change my DB to support 5 different languages. Right now the collation is 'SQL_Latin1_General_CP1_CI_AS'. I've changed datatype to NVARCHAR and inserted the different languages....

I don't think SSIS is a good choice for this job. SSIS is all about moving and manipulating data. Creating PDF files is not really one of it's standard tasks.

Regarding...

Who installed the SQL Server instance?

They should have appointed users to have admin privileges.

Is Mixed Authentication turned on? Is the sa account available?

Since there's no actual limitation on the...

margaret.whitaker 14947 (1/31/2012)

---

Thanks for the explanation, can you elaborate on the connection manager part. Give an example? When I indicate a flat file for the log provider, a...

SQL Kiwi (1/31/2012)

---

Koen Verbeeck (1/31/2012)

---

I've downloaded SQL Server 2012 RC0 to play with and to prepare myself for a session I'm going to give in a month. During installation, set-up...

It seems you can SQL Server Developer edition on Windows Home SP3:

Hardware and Software Requirements for Installing SQL Server 2008 R2

Developer edition is free if not used in production and...

😀