Reddy Ksr (6/27/2012)

---

i got this error when i tried this type of task.

can anyone suggest me about the error?

Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the...

You can either read the flat file is a fixed width file, specifying lengths for each column and keeping all the columns you need.

Or you read the data is one...

would you like to share it, so that people finding this thread through a search engine may profit of it as well?

Multiple fact tables but with (almost) identical structure and type of data is confusing for your end users. I would merge them together in the data source view and use...

This article explains it all:

Looping over files with the Foreach Loop

In your case you need to use the wildcard data*.txt.

But I would recommend you still read the book mentioned by...

Got burned by this one. Very interesting question, good job Steve.

Stefan Krzywicki (6/27/2012)

---

Koen Verbeeck (6/27/2012)

---

Stefan Krzywicki (6/27/2012)

---

Koen Verbeeck (6/27/2012)

---

Grant Fritchey (6/27/2012)

---

Koen Verbeeck (6/26/2012)

---

Well, I did the best I could.

I 'liked'...

Stefan Krzywicki (6/27/2012)

---

Koen Verbeeck (6/27/2012)

---

Grant Fritchey (6/27/2012)

---

Koen Verbeeck (6/26/2012)

---

Well, I did the best I could.

I 'liked' the book on Amazon,...

Grant Fritchey (6/27/2012)

---

Koen Verbeeck (6/26/2012)

---

Well, I did the best I could.

I 'liked' the book on Amazon, gave it 5 stars...

What type of server is MYDBNAME?

My guess is the SQL Server Agent account doesn't have the necessary permissions. Use a proxy to circumvent this issue.

A query parameter is a parameter used in your dataset. This automatically results in the creation of a report parameter. When you run the report, you need to specify values...

It works fine with me.

Do you have the right permissions?

I think the syntax is wrong.

Try calling your sp like this:

EXEC dbo.uspGetEmployeeManagers @EmployeeID = 6;

vk-kirov (6/26/2012)

---

I can create an index by means of a unique constraint:

CREATE TABLE dbo.QotD

(KeyColumn int NOT NULL PRIMARY KEY,

RefColumn int NOT NULL,

-- ...

Well, I did the best I could.

I 'liked' the book on Amazon, gave it 5 stars and wrote a small...