I was able to resolve this issue by generating the DLL file using Visual Studio 2008, instead of Visual Studio 2010. I had to first install Visual Studio 2008,...

As a follow up, I found that applying the RAISERROR will create a message in the queue with a status = 1, but does not automatically disable the queue, as...

Thanks for your help. I was overthinking things and realized that all I had to do was temporarily apply a "SELECT 1/0" in my activation stored procedure and that...

My personal desktop computer at work is running Windows 2008 as the OS. When I open SQL Server Management Studio and select Connect > Database Engine, I can connect...

Thanks Braindonor, I'll give that a try.

Typing up the details of my issue helped me to see and resolve the problem. The page break was not set up correctly. Now a new page break...

When you test the access by entering the UNC path to the SharePoint file in Windows Explorer, is that from your personal local computer or from the server where SSIS...

Yes, I meant to say "Team Foundation Server."

I was able to resolve this issue by applying "LocalHost" in place of the server name. Since the only thing that will...

I was able to resolve this issue with a simple modification. The file being imported had a .csv extension and that was causing SSIS to interpret it as related...

Lynn, I applied the steps you recommended, but when I reran the same two SQL statements afterward, the results were the same. No records were returned having a Notes...

I ran the following query:

SELECT Notes

FROM Tasks_import

WHERE len(Notes) = 255

Then I copied and pasted several values from the Notes field results into NotePad and I could see that the sentences...

🙂

The process is now working. It turns out that I was applying the wrong variable for the destination in the File System Task nested in the Foreach Loop container....

Yes, I set up the File System Task within the Foreach loop container as discussed in my previous message. I edited my response with this additional detail while you...

Okay, I applied those steps and within the Foreach Loop container set the Enumerator to 'Foreach ADO Enumerator', the ADO object source variable to 'user::vFileName' (the variable object being populated...