Viewing 15 posts - 1,396 through 1,410 (of 2,268 total)
For the developers/dbas you can use Visual Studio to view the databases,
but unless your users are developers/dbas , then they should not be accessing the databases directly, you should...
May 15, 2009 at 5:28 am
Shukla (5/15/2009)
This message comes.
Right now my database is not corrupted but i want to start my live data on sql server.
That continously users will be working on my...
May 15, 2009 at 4:10 am
You must have show exectution plan option turned on, turn this off and this query should run fine.
its also worth noting that
where 1=0
means that your query will never...
May 14, 2009 at 10:56 am
The Alternative would be to remove the logic that is contained in the function and add this to your procedure, it could be added as a CTE or Temp...
May 14, 2009 at 8:51 am
you can manauly edit the data destination conneciton manager to change order of the columns, though this may take a while.
An easier way is to delete the connection manager...
May 14, 2009 at 8:29 am
are you doing regular transactional log backups?
if not do these first as these will mark space in the logs for re-use
May 14, 2009 at 7:52 am
No i don't sorry, i run all my packages on SQL server as jobs and load the variables from tables.
I can ask one of the guys here...
May 13, 2009 at 11:00 am
If you go into the properties window of the file connection and click on expressions, click on (...) for a new expression.
Here you can select 'Row Delimeter' from...
May 13, 2009 at 10:47 am
Also be aware that depending on where you live and the laws in your country, using certain production data for software testing can be illegal. Here in the UK...
May 13, 2009 at 10:03 am
you can type any value you want into the row delimiter in the flat file connection manager, it is under the columns tab in the connection manager editor
May 13, 2009 at 9:59 am
Check your SQL server logs, and this will show you why the user can not connect
May 13, 2009 at 9:15 am
Samuel Vella (5/12/2009)
I used this data:123435
1124015359
1234
1
2
3
4
and created a new derived column using the following:
([Column 0] == "" ? "0" : [Column 0])
and it worked fine
be careful with this sort of...
May 12, 2009 at 8:46 am
change the error settings on the data transformation to re-direct the rows in case of an error. Send these error rows to a table or flat file and...
May 12, 2009 at 7:39 am
you should be able to use ROW_NUMBER() for this, have a look at BOL for the syntax, or post your table defs and some sample data for...
May 12, 2009 at 7:34 am
I would create a stored proceure for this, to make the query efficent and as fast as possible, uou shoud create the appropriate indexes and not use select...
May 12, 2009 at 3:58 am
Viewing 15 posts - 1,396 through 1,410 (of 2,268 total)