Viewing 15 posts - 6,706 through 6,720 (of 11,678 total)
Eric Hobbs (7/13/2012)
Koen Verbeeck (3/21/2011)
tmcdermid (3/20/2011)
You can connect SSMS 2008 to an SSIS 2005 "instance" - but there's not much need to do so.
Are you sure? I always got an...
July 13, 2012 at 5:15 am
Evil Kraig F (7/12/2012)
July 13, 2012 at 12:38 am
This is how I would do it:
1. Store the names of the databases in a table.
2. Execute a SQL query that fetches the database name. Store the result in an...
July 12, 2012 at 11:54 pm
How did you do the parameter mapping for task ?
How does the query of task look like?
What are the errors that you get?
July 12, 2012 at 11:42 pm
Anyone familiar with linked server from SQL Server 2012 to SQL Server 2000 and MS DTC?
http://www.sqlservercentral.com/Forums/Topic1328003-2799-1.aspx
July 12, 2012 at 2:43 am
Your caps lock is broken.
Does your user have access to the database? If yes, try another option: service account, default or specifying an explicit user.
July 12, 2012 at 2:13 am
Which impersonation option did you choose in the datasource?
July 12, 2012 at 1:10 am
You have to make sure SQLNCLI10 is used, as SQLNCLI11 doesn't support connections to SQL Server 2000. Which provider did you choose in the Linked Server menu?
July 12, 2012 at 12:35 am
Maybe a little bit too easy 😀
But apparently some people still get it wrong.
Or maybe they just sneezed while picking the answer and thus accidentily clicking the wrong button.
July 12, 2012 at 12:26 am
Ah yes, I misread the question. I thought the parameter was used internally, so using a second parameter is an option (if you use the query to populate default values).
Sorry...
July 11, 2012 at 1:56 am
* Handling files (renaming, copying et cetera). A script task is more flexible and robust than a File System Task. And it's easier to add a timestamp.
* using regular expressions
*...
July 11, 2012 at 12:34 am
I don't think you can populate a third field, but you can use a second parameter that will take the value for FieldC and use that one.
July 11, 2012 at 12:28 am
SQL* (7/9/2012)
which is the best option, whether to load data from csv or from the sql server table.
I have export the data from sql to any staging like csv/sql...
July 10, 2012 at 12:18 am
Viewing 15 posts - 6,706 through 6,720 (of 11,678 total)