Ok the installation worked and fixed the problem with the service running. I then followed the books instructions and ran the following installation. AdventureWorks2008_SR4.exe. Now SSMS 2008 won't connect AT...

From the following two links it appears that the problem is with SS2012. They say that if i uninstall it 2008 should work. They also both seem to suggest that...

See how lost i was, i didn't even know that was the actual BOL on Merge. I thought i was in the wrong place. 😉 I should have it on...

So how do you find this on BOL? I've been searching all over MS website and all i can find is one article.

This is the only thing i've found.

http://msdn.microsoft.com/en-us/library/bb510625.aspx

BOL...

I could never understand the BOL so I've always avoided it. But I'll take a look.

Sorry about the sample data. I got into a rush and should have tested...

Well there is a sample. No I've not tried BOL on Merge. I'll check it out thanks!

Here is the table structure and some sample data.

CREATE TABLE [Batches](

[FileName] [varchar](256) NULL,

[cpFolderPath] [varchar](1024) NULL,

[eFolderPath] [varchar](1024) NULL,

[PayerPath] [varchar](1024) NULL,

[ProviderPath] [varchar](1024) NULL,

[cdbConnection] [varchar](256) NULL,

[rdbConnection] [varchar](256) NULL,

[CustomerID] [int] NOT NULL,

[ImportTF] [bit] NOT...

Thanks very much!

Thanks guys! It sounds like doing the staging table is the easiest. This is just an exercise for my internship to help me understand how to use SSIS....

I'll be getting an upgrade soon. thanks!

Thanks Gila! I'll have to do it on my laptop when i get home. i don't have any test databases I can play with here at work.

I guess SEEING...

Well I guess

EXEC sp_executesql @sql, N'@custid nchar(5), @shipname nvarchar(40)',

@custid, @shipname

Gives...

Ok thanks for the info. Right now I'm trying to avoid D-SQL until i learn more about it.

The TVP seems, at least in my head, like an alternative method although...

Thanks very much for the information. I'm currently an intern. My supervisor is giving me the opportunity to weigh out different approaches.

He suggested that i could perhaps pass the SP...

Sorry I don't mean end user. To me a user is who is going to be using my stored procedure. Perhaps i should say developers but that too is ambiguous...