I don't have any intensions of personal attacks on any one, since I have been following the post, I am surprised would there be anyone trying for a way to...

RV-813525 (10/24/2008)

---

I am quite a novice and learning SSIS. The package is stored on the local machine and the Database server is the different machine. I am accessing the data...

It must be another Dataflow Source, and your Table where you want to insert data is your Destination.

Then I guess you must have got this as an Interview question somewhere.

Rather than that I have not idea why would you want to do it.

Speaking...

Do you Recordset from a T-SQL Statement?

If thats what you need, then

INSERT INTO TABLE ( COL1, COL2 , COL3 )

SELECT COL1, COL2 , COL3 FROM YOUR QUERY

Even for a novice programmer, Insert into tablexyz Select Columns from tableabc should be a easier one right?

From the first look, I cant understand what you trying to do here?

EXEC (@AD_Fetch_Data) ----- What do you want to execute?

@AD_Fetch_Data is going to store this value "TransactionErrorAuditID, TransactionErrorAuditSequentia,...

You could right click and open the table using Management Studio. Click in upper most left hand corner to highlight all records and right click copy. You would then open...

Since this is not an urgency, I guess you can wait and I can try posting a script in later in the day. I am running short of time to...

You can restore the System databases MSDB and Model, try finding a good blog on that.

What I achieved was actually a bit more adventurous, I stopped SQL Server and replaced...

Yes, try attaching using the Stored Procedure.

You mean you want the entire Stored Procedure script ? or you need some help? if so what is that you are looking for?

I guess you might have already registered the Server in your SSMS Registered Servers.

If so, then right click on the Server Name and select Properties.

Then you have 2 tabs, In...

First thing First you say its 2008 and posted in 2005 Forum and also if I am not wrong you are talking about SSIS Packages, which should have been posted...