|
This should be fairly simple, but I'm rather new to SSIS.
I want to copy data from one table to another. The column names are not the same, and in the target table I may need to expand some columns so I don't get truncation errors.
I'm not really sure what objects in SSIS to use.
Many thanks
Everything makes sense in someone's mind
|
|
|
|
|
If the copy operation is quite simple, try following:
- define a Data Flow task and open it
- using Source Assistant, define the source database
- using Destination Assistant, define the destination database
- configure the source table for OLE DB Source (double click it to open the confiiguration)
- do the same for OLE DB Destination
- if you need expressions, add a Derived Column
- configure the derived column; add necessary new derived columns, their expressions etc
- connect the source to the derived column
- connect the derived column to destination
- in OLE DB Destination configure the mappings
Hope this gets you started 
|
|
|
|
|
|
I was thinking, can Microsoft SQL Server handle projects such as Facebook, Linkedin, etc? and if answer is Yes, then why they didn't go for it?
|
|
|
|
|
Don't quite understand the question. Those examples you gave are applications consisting of several different layers etc.
If you mean that could Sql Server serve as the back-end for the data, why not? Sql Server is capable of data distribution between several server, workload balancing, distributed transactions etc. so I see no direct reason why it couldn't handle the data.
|
|
|
|
|
It can handle the data and workload, its just that these online companies and startups (as they were) opted for the cheapest option (ie free) back when they started up, to minimise startup costs. They carry on using these systems as it will be too costly to migrate onto another platform.
Simple economics really..
JC
|
|
|
|
|
Yes, from the economics point of view the situation is different. For example Oracle has quite good concept now when MySql can be used when starting up and when performance etc problems arise, you can migrate to Oracle with a bit less work than to other database flavors.
|
|
|
|
|
Services like Facebook etc. need to be massively parallel and fault tolerant, to get the same level of service from sql server would mean a heavy investment in licenses, also these sites are using unix servers and sql server is not supported on them.
Its the man, not the machine - Chuck Yeager
If at first you don't succeed... get a better publicist
|
|
|
|
|
The simple answer is, yes, SQL Server can handle the volume of data these sites catered for. The key thing to note about these sites, though, is that they tend to opt for NoSQL[^] databases - which is not what SQL Server is designed to do.
|
|
|
|
|
As said before, it's a financial decision. The Amaren[^] Nuclear Plant, and MacLaren[^] are using Sql Server. To be fair; they're doing something more complex than putting some html-pages in there
Bastard Programmer from Hell 
|
|
|
|
|
And I'm betting they have a serious investment in SQL Server licences. And they will almost certainly have had direct support from MS if they are pushing the edge of the tech. I know we were offered all sorts of incentives to use MS high volume framework including direct intervention from MS techs. Mind you the licences were $1m+.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Pretty sure most companies are more than willing to offer incentives and support for large contracts.
And if one goes with a non-paid solution then of course one had also be prepared to provide ones own support for all possible problems.
|
|
|
|
|
if sql server can handle NASDAQ[^] then it could handle anything any of us could throw at it.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
|
|
|
|
|
I am using a password protected DB. When i try to read from that table from another DB it is asking for the password. how to give the password. my query looks like this
" insert into table select from table in 'database'" .
in which the database is password protected. Any idea?.....
|
|
|
|
|
|
Hi,
Please let me know how can i check whether the i/p parameters were
Null or empty and raise error and let user know that particular parameter is null or empty when he is trying to execute the SP (Stored procedure)....
|
|
|
|
|
You mean inside the stored procedure? You can use IS NULL operator:
create procedure foo @param1 decimal as
begin
if @param1 is null
begin
raiserror('param1 is null', 16, 1);
end;
end;
exec foo 1;
exec foo null;
|
|
|
|
|
create procedure Myproc @myvar1 decimal as
begin
if @myvar1 is null
begin
error('@myvar1 is null', 16, 1);
end;
end;
|
|
|
|
|
Yes, what Mika said, but you're still better off wrapping a Data Access Layer around your database to check things like that.
|
|
|
|
|
You can check your parameter is null or empty. there are various way in sql server or oracle database.
declare @IP NVARCHAR(SIZE)
IF(@IP IS NULL OR @IP = '')
BEGIN
SQL STATEMENTS.
END
ELSE
BEGIN
SQL STATEMENTS.
END
IF(@@ERROR > 0)
SQL STATEMENTS.
|
|
|
|
|
Hi..
check your parameter is null or not.
in stored procedure
if(parameter is null or parameter ='')
begin
sql statements
end
else
begin
sql statements
end
or
in single query.
select * from tbl where parameter is null or parameter =''
|
|
|
|
|
Trying to install the following patch to fix a SqlBulkCopy/ADO.NET timeout issue when loading data
http://support.microsoft.com/kb/913177/[^]
However, when I run the installer "ndp20-kb916002-x86" (SQL 2008 on 32 bit Windows 2008 server), I got the following message:
"The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing , or the upgrade patch may update a different version of the program"
Has anyone run into this problem before?
Thanks
dev
|
|
|
|
|
Haven't seen that problem but could be related to the fact that the fix is older than your server environment. As a workaround, have you tried enabling MARS?
|
|
|
|
|
Dear all,
Please kindly advise this, my storeprocedure structure is as below.
The purpose is, While Insert in TableA if there is any error occour Then I want to ROLLBACK TRAN of TableB that related with the current Transaction of TableA, if not COMMIT TRAN.
When execute it I have got the error
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1159.
DECLARE Cur_1 Cursor LOCAL FOR
Select col1,col2,col3 from table1
OPEN Cur_1
FETCH NEXT FROM Cur_1
INTO @col1,@col2,@col3
WHILE @@FETCH_STATUS = 0
BEGIN
DELETE FROM FROM TableA Where match with @col1,@col2,@col3
DELETE FROM FROM TableB Where match with @col1,@col2,@col3
DECLARE Cur_2 LOCAL FOR
Select * from table2 Where match with @col1,@col2,@col3
OPEN Cur_2
FETCH NEXT FROM Cur_2
WHILE @@FETCH_STATUS = 0
BEGIN
BEGIN TRAN
INSERT INTO TableB (data from Cur_2 & Cur_1)
FETCH NEXT FROM Cur_2
END
CLOSE Cur_2
DEALLOCATE Cur_2
INSERT INTO TableA (data fromCur_1)
IF @@ERROR = 0
COMMIT TRAN
ELSE
ROLLBACK TRAN
FETCH NEXT FROM Cur_1
INTO @col1,@col2,@col3
END
CLOSE Cur_1
DEALLOCATE Cur_1
modified on Friday, September 2, 2011 12:35 AM
|
|
|
|
|
Your problem is that your BEGIN TRAN statement is inside a WHILE loop and hence it will be executed every time the loop code is executed. You need to move it outside the loop.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
