Have you tried using NOTRUNCATE to move all pages towards the beginning of the file?

Try this:

DBCC SHRINKDATABASE(database_name, NOTRUNCATE);

Then try shrinking the data file again.

That message sounds to me like the SMS portal is down. I would start with whoever maintains http://122.22.12.12/smsportal/sendsms.aspx.

Why the Execute SQL Task? That will not help you efficiently load files from SSIS. Did you mean Data Flow Task?

Looping Through and Loading Files with SSIS

Process all records how? Out to a flat file? Into another database? Please provide more detail about what you're trying to do. Also, posting your table definitions may help us...

You may not need to rig something like that up. What event are you waiting to see happen before your Script Tasks do work? Are you by chance polling for...

SQL Server 2005 Best Practices Analyzer

SQL2005SecBestPract.doc

DB_Newbie2007 (4/2/2012)

---

Unfortunately, since the the Stored Procedure pegs the CPU at 100% (and this is a Production system), the Execution plan cannot be viewed as it appears to stop running...

Thanks for brightening this Monday morning GSquared 🙂

From the SQL Server 2005 documentation for sp_change_users_login

sp_change_users_login (Transact-SQL)

sp_change_users_login cannot be used with a SQL Server login created from a Windows principal or with a user created by using...

OK, tables, yes, I was aware that you could select more than one table in the wizard but the OP was asking about flat files.

I did not know you could use the I/E Wizard to create more than one Data Flow task in a single package.

http://connect.microsoft.com/SQLServer/feedback/details/278452/there-needs-to-be-a-way-to-preserve-order-when-bulk-loading-a-file

Jeff Moden (3/31/2012)

---

opc.three (3/31/2012)

---

Jeff Moden (3/30/2012)

---

It's been a while but, IIRC, if you set MAXDOP to 1 and...

PS I do not use BULK INSERT, but I am not finding any articles claiming MAXDOP 1 will have the desired effect. I am reading that TABLOCK may be part...

Jeff Moden (3/30/2012)

---

It's been a while but, IIRC, if you set MAXDOP to 1 and you have no...