Viewing 15 posts - 181 through 195 (of 405 total)
You will not find a scope like parent variable. You should create a variable as normal and scope it either to package or task level.
In youre package configuration you should...
February 28, 2013 at 10:48 pm
This is an error associated with replication.
start here
http://www.sqlservercentral.com/articles/Stairway+Series/72274/
February 27, 2013 at 8:20 pm
The error clearly says that you cannot insert null to organazationId column. I assume this column to be not null or even primary key.
If it is not null try inserting...
February 25, 2013 at 9:44 pm
in ssms - Tools > Options > Query Results
You will find that the charecters that can be diplayed in each type has an upper limit.
But while using the variables...
February 25, 2013 at 9:29 pm
If you have not found already.
Server srv = new Server();
//Reference the AdventureWorks2008R2 database.
Database db = srv.Databases["AdventureWorks2008R2"];
//Define a Scripter...
February 25, 2013 at 8:11 pm
How did you restore the database?.
While restoring did you add with norecovery?
February 25, 2013 at 8:02 pm
What is the problem of using varchar(max). I think 2GB is well enough for any query.
If you are printing or selecting from the variable, the output result may be truncated...
February 25, 2013 at 7:57 pm
What is the status of your databse as per management studio?
What error you have in your error log?
February 25, 2013 at 7:46 pm
What is the error you are getting for the C# script.
Also you must add refernce to classses
using Microsoft.SqlServer.Management.Smo;
using System.Collections.Specialized;
You need to add references in SSIS project for
Microsoft.SqlServer.Management.Smo
and
Microsoft.SqlServer.ConnectionInfo
February 25, 2013 at 3:57 am
Got it.
You mean generate database scripts periodically.
In fact there is not out of the box solution for this in SSIS.
However you can use SMO using c# to acheive this.
http://stackoverflow.com/questions/3488666/how-to-automate-script-generation-using-smo-in-sql-server
You can...
February 25, 2013 at 2:51 am
Just by partitioning we cannot be sure to get performance benifit.
You should look at your queries and execution plans and see partition elimination is happening.
look at your frequent / long...
February 25, 2013 at 2:32 am
Can you provide more details ?
What scripts you are trying to automate , backups ?
February 25, 2013 at 2:27 am
can this help?
http://stackoverflow.com/questions/6350442/gpg-error-code-2
Also make sure the succes value is the correct one. Most process has 0 for success. I gave you that suggestion only because you said the file was...
February 21, 2013 at 10:08 pm
Hi,
Replication is more like a reporting solution, it gives you choice of tables ore even columns that needs to be replicated.
Mirroring can be considered as DR (I had...
February 21, 2013 at 9:30 pm
Viewing 15 posts - 181 through 195 (of 405 total)