oneteabag (9/22/2016)

---

So if I elect to create 3 different databases. The first DB which is holding source data, should I create different schemas inside this database referencing the different data...

Jerid421 (9/22/2016)

---

Hi,

I am relatively new to SSIS packages and am in the process of creating my own data warehouse from an existing data warehouse. There are about (21) tables...

Brandie Tarvin (9/22/2016)

---

Phil Parkin (9/22/2016)

---

Yep, I am...

jwiesman (9/22/2016)

---

Good Afternoon.

I'm trying to write a "quick and dirty" package in VS2010 to provide me space usage for a database.

This is the query I'm now running manually in SSMS:

use...

oneteabag (9/22/2016)

---

Hi all,

I have a quick question about data flow process best practice as follows:

I am pulling data from various data source using SQL code (SP & SSIS PKG) to...

Yep, I am totally puzzled as to...

CharlieRL (9/22/2016)

---

I am currently writing an SSIS package to migrate data from one third party database to a new third party one. This new third party uses a key...

Something like this?

SELECT tbl.tbl

, sql = CONCAT('DROP TABLE ',tbl.sch,'.',tbl.tbl)

FROM sys.dm_db_partition_stats ddps

CROSS APPLY (SELECT sch = OBJECT_SCHEMA_NAME(object_id)

...

I'd write a query to identify (only) the empty tables. Add a column to the query which returns the 'DROP TABLE ...' statement, for the selected table.

Execute the query, copy...

JALLYKAMOZE (9/21/2016)

---

I changed the file to a .txt file, see the error i am still getting:

NULL

Starting copy...

SQLState = 22005, NativeError = 0

Error = [Microsoft][SQL Server Native Client 10.0]Invalid character value...

JALLYKAMOZE (9/21/2016)

---

output

User name not provided, either use -U to provide the user name or use -T for Trusted Connection

usage: BCP {dbtable | query} {in | out | queryout | format}...

Can you paste the text of the error message, please?

GilaMonster (9/21/2016)

---

I strongly recommend you reconsider the entire process.

Leave .net out, other than to call the stored procedure. Write the load process in T-SQL in a single batch. Do the...

Sue_H (9/20/2016)

---

Phil Parkin (9/20/2016)

---

Sue_H (9/20/2016)

---

You could try changing your temp tables to global temp tables and see if that makes a difference. What you are seeing can often happen with...

This feature is deprecated (see here).

So I suggest you consider an SSIS/CDC solution, as recommended by MS, instead.