Sangeeth878787 (1/13/2016)

---

Hi,

I have come across situation where I need to load sql table from multiple flat files, I have created SSIS package with Data flow task, For Eachloop Container and...

An underlying point in all of this is that you should already have had most if not all of this stuff scripted and in a version control repository so that...

You can install multiple versions of the IS binaries on a server. In this case you could run the Packages using the version of DTExec.exe installed with SQL Server 2005...

Is this a third-party SFTP Task you downloaded and are using in your SSIS Package? Are you saying it works locally running in Visual Studio but not when hosted on...

Counting the number of lines in a flat-file in a Script Task in SSIS is trivial and wicked fast. You can then take that count and compare it to the...

An oldie but goodie: Deleting Large Number of Rows[/url]. Note the SQL 2005 code is compatible with all newer versions of SQL Server.

The technique in the article will delete rows...

Welcome. Thanks for posting usable DDL, test data and desired results. What have you tried so far?

Sounds like a security problem to me. You need to get on top of the permissions your users have and reign in the permissions for the users you are concerned...

It's a Big, BIG topic you are asking about. Some vendors have taken a legitimate shot at solving the issue and providing a methodology and supporting tools to do this....

Luis Cazares (1/13/2016)

---

Orlando Colamatteo (1/13/2016)

---

NineIron (1/13/2016)

---

I'm running a procedure that I received from a vendor and I got a maximum recursion 100 error or something like that. So, this means...

NineIron (1/13/2016)

---

I'm running a procedure that I received from a vendor and I got a maximum recursion 100 error or something like that. So, this means that it "looped" 99...

Precisely,...

caojunhe24 (1/13/2016)

---

Hi experts,

Can anyone help me to create the logic that I need??

Logic --->If a month changes in week, then week volume should be attributed to month with more no...

A lighter way to introduce the topic to folks for the first time, I have found, is through the The Droste Effect.

barry.mcconnell (12/31/2015)

---

Sadly, what I'm not seeing companies embrace is the need for proper data architecture and administration. I laugh when I hear "data scientists" moan about how 80% of their...