As an aside, it is a best practice in SQL Server for all tables to have a clustered index and a primary key. Any reason why this table should not...

sqlinterset (2/1/2016)

---

I have a transnational table which every time dropped and created in a job to get updated data.

Earlier there was no index, but now one non-unique, non-clustered index was...

VCS needs to be taught in College and on Day 1 of onboarding in a new job. I find that with application developers (by apps I am targeting compiled apps...

I think you are making this harder on yourself than it needs to be. Do not let the C# aspect intimidate you.

Ingredients:

1. Stored Procedure

2. SSIS Package

3. Database Connection String

4. SMTP...

I thought this was resolved...you meed to use an Output Parameter not a Resultset to get the MAX-value from the database into an SSIS Variable.

https://msdn.microsoft.com/en-us/library/ms403365(v=sql.120).aspx

If memory serves (mobile so cant test) mkdir will make all dirs in the hierarchy if they are missing. So, just say

mkdir C:\Dir1\Dir2\Dir3

and if Dir1 and Dir2 do not...

Looks like the OP reposted:

http://www.sqlservercentral.com/Forums/Topic1757179-3412-1.aspx

OK, attached is an SSIS Package that uses only native SSIS Tasks and Components and T-SQL, i.e. no C# Script is utilized in the SSIS. Files included in the attached...

No problem. Just a general sense of concern that you're creating a security exposure and that from a troubleshooting perspective having the behavior change after making a change like that...

Just in case it wasn't clear before, you should not need to have

NT AUTHORITY/SYSTEM setup as a Login on your SQL Server instance and you definitely should need to...

Jeff Moden (1/30/2016)

---

Thank you for the post on how to load the SSIS package. I appreciate the time you took. I'll have to pass, though. I was...

Jeff Moden (1/30/2016)

---

@mxy,

BTW, what was the DOS command that you used to create the file? The reason I ask is because there may be a simpler method available but...

I...

Jeff Moden (1/30/2016)

---

@orlando,

I've gotten away from SSIS so much that I don't even know how to open SSIS and load a package. I'm really interested in seeing what you've...