Posted
by Nev_Rahd
on Stack Overflow
See other posts from Stack Overflow
or by Nev_Rahd
Published on 2010-04-19T02:28:04Z
Indexed on
2010/04/19
2:33 UTC
Read the original article
Hit count: 292
How can i Load Temptable on Server B by reading data from Server A in Dataflow task.
© Stack Overflow or respective owner
as seen on SQL Blog
- Search for 'SQL Blog'
When you install SQL 2008 R2 workstation components you get a newer version of BIDS (BI Developer Studio, included in the workstation components) that replaces BIDS 2008 version (BIDS 2005 still live side-by-side). Everything would be good if you can use the newer version to edit any 2008 AND 2008R2…
>>> More
as seen on SQL Blog
- Search for 'SQL Blog'
Often when using SQL Server Integration Services (SSIS) you will find there is more than one way of accomplishing a task and that the most obvious method of doing so might not be the optimal one. In the video below I demonstrate this by way of an experiment using SSIS’s Flat File Source component;…
>>> More
as seen on SQL Blog
- Search for 'SQL Blog'
In recent blog posts I have introduced the new SSIS Catalog that is forthcoming in SQL Server Code-named Denali:
What's new in SSIS in Denali
Introduction to SSIS Projects in Denali
Parameters in SSIS In Denali
SSIS Server, Catalogs, Environments and Environment Variables in SSIS in Denali…
>>> More
as seen on SQLIS
- Search for 'SQLIS'
I stumbled across a new SSIS tool on Codeplex today, the SSIS Log Analyzer which was only released a few days ago. Whilst it is a beta release and currently only supports 2005 (2008 is promised) it looks quite interesting. It seems to be a fancy log viewer, but with some clever features and a nice…
>>> More
as seen on SQLIS
- Search for 'SQLIS'
I stumbled across a new SSIS tool on Codeplex today, the SSIS Log Analyzer which was only released a few days ago. Whilst it is a beta release and currently only supports 2005 (2008 is promised) it looks quite interesting. It seems to be a fancy log viewer, but with some clever features and a nice…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am simply taking the data from a Table and insert it into #tempTable then delete the data, and insert it back to the table. I get "Insert Error: Column name or number of supplied values does not match table definition." Error.
Here are the lines I am running.
SELECT * INTO #tempTable FROM dbo…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
I'm getting the following error whenever my code creates a DataTableReader from a valid DataTable Object:
"DataTableReader is invalid for current DataTable 'TempTable'."
The thing is, if I reboot my machine, it works fine for an undertimed amount of time, then dies with the above. The code…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
How can i Load Temptable on Server B by reading data from Server A in Dataflow task.
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
Many years ago I wrote article SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server where I demonstrated using undocumented Stored Procedure to find the drive letter in local system and available free space. I received question in email from reader asking if there any way he can list…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I've been looking into SQL recently and exploring a bit. in regards to Temp Tables I have discovered 3 different temp table types:
1) CREATE TABLE #TempTable
2) DECLARE TABLE @TempTable
3) SELECT * FROM (SELECT * FROM Customers) AS TempTable
Now I understand the scope behind the #TempTable and…
>>> More
