PS, I guess it's coz of too much traffic... problem automaticaa solve aagidichu...:) Thanks...:)Quote:
Originally Posted by PARAMASHIVAN
Printable View
PS, I guess it's coz of too much traffic... problem automaticaa solve aagidichu...:) Thanks...:)Quote:
Originally Posted by PARAMASHIVAN
No Probes, Dev :)
I am trying to do a bulk insert
BULK INSERT dbo.SSIS
FROM 'c:\conf2010 to be imported.csv'
but I keep getting an error saying
Msg 4832, Level 16, State 1, Line 1
Bulk load: An unexpected end of file was encountered in the data file.
any ideas pls ?
Kirukan or others
Does any one know where Relication details are kept (in which database adnin which tables) ?
I thought it would be in MSDB database, but I cant find any tables relating to Subscription, publishing and distribution ?
thanks
Hope u got answer for this if not....Quote:
Originally Posted by PARAMASHIVAN
By default it will be stored in database called distribution in distributor database server.User can customize his own...
http://msdn.microsoft.com/en-us/library/ms189755(SQL.90).aspx
Kirukan
Thanks Kirukan :)
BTW Do you know much about SSIS packages in SQL server 2008 ?
I have a package that Copies 10 tables from a Database on SQL server 2005 to SQL server 2008 .
Now I have chosen the option to Drop and recreate tables as well as delete rows in the destination tables before copying the data accross, this should eliminate Primary key violations right? but I am still getting them
any ideas
thanks
Anyone familiar with OWSM? If so, need clarification for some of my queries in understanding the conceptual design.
Ideally it shud eliminate Primary key violation...you physically drop the table and check the same.If it persist even after that then compare the structure of the source and destination tables...it may be a genuine primary key violation...we use SQL compare for this.....Quote:
Originally Posted by PARAMASHIVAN
கிறுக்கன்
Thanks Kirukuan
I will compare the structures of the source table and destination table and see
I have a contact table, and a course table. Now some of them have attended the course and some have not, how would I find the ones who have not attended the course ?
would be be contact left outer join, right outer join??
pls advice