thank you folks, use the transfer sql server object and done in a second,

much appreciated thank you.

Sonal.

Could you elaborate a bit more about the input output wizard, i am quite new at ssis and under a tight deadline

currently searching google on this subject as well

Elliott,

I have 190 tables, I don't want to create them all one at a time

Sonal

Phil,

I added the parameters at the container level

then went ahead and added them in the parameter mapping of the execute sql task

The parameter name is User::ProdDB

I set the newparameter name...

Brandie,

It is a Execute SQL Task. Trying to move tables from a sql server staging database to a production database

I have created two variables at the container level, not sure...

Roger tried to access the two microsoft links you referred to and access is denied per "Corporate Policy"

Sincerely,

Sonal

I am still waiting for the sybase drivers to be loaded, so cannot use the import wizard on SQL Server yet.

If I used the import wizard on SQL Server, will...

Thank you.

Best case scenario would be to dynamically create the tables from Sybase to SQL Server and populate them.

Would love to see some code examples.

Thank you sonal.

Hmmmm, it seems you have...

John,

I am not sure about SQL 2000 in 2005, I don't believe the Transaction log is automatically truncated when you do a backup, you have to physically shrink it.

Sincerely,

Sonal.

just had this happen to me, grant view any tables to the user and this should work.

let me know.

sonal.

I had actually run a script to tighten security. We have a Microsoft PFE that works with us, and he thought to look at what privileges allows users to view...

view any database had been revoked by a script we ran to tighten security, that's is what did it.

granted individual access to user

thanks to all for helping

sonal.

yes the user is connecting through ssms

for security reasons cannot print screen shot, this is from ssms, no error, he just cannot see the databases that i have given read access to, no deny has been...