If you right-click on a table in the object explorer and select "Edit Top 200 Rows", you can get a usable query designer that will execute. You can add,...

Your dynamic SQL creates a new session that knows nothing about the delcared variables you set in your "normal" session. You will need to declare and set you variables...

As Roy indicates, you can delete your child records and then delete the parant records. If the relationships are cascading, you can drop the parents and the children will...

It might be faster to collect the last 7 days worth of data into a new table, drop the original, then rename the new table.

If the only deleting done to the published articles is to purge old data, then set your "Do Not Replication DELETE Statements" option under the Statement Delivery section of Article...

Have you validated the subscriptions? Are you doing any filtering?

If the subscription is out of sync with the publisher, you will need to reinitialize.

You can reinitialize without doing a...

Have you checked for blocking processes? Also, are you using any triggers on the affected tables?

This can be caused by partially removed publications that leave metadata behind in the distribution sys tables. You can search for removed publications in the MSpublications, MSsnapshot_agents, MSpublisher_databases and...

reflorio (10/2/2009)

---

I am trying to run a stored procedure from a sql task that takes a package variable as an input parameter. Eventually want to pass the value to...

With the constraints back on, data inserts violating the constraints will be rejected, but the "bad" data loaded thru SSIS with Check Constraints set to FALSE will remain in the...

I'm not aware of any way to do this in SSIS.

Sharepoint does store documents in SS tables, but you would have to know how to re-assemple the data in the...

I would first make sure you are using the connection you think you're using. Then make sure that connection is pointing where you think it's pointing.

Have you tried outputting to a raw file destination? I believe this would do the trick, but I have not tried writing binary data.

How are you scoping the variable you are passing?

I believe it should be scoped to the outer ForEach container or to the package.

MP packages are stored in msdb. You can look on the dbo.sysssispackages table for them.

Is your development server an instance name on the server? SSIS has trouble finding...