Solved

How to remain the SQL script format if we copy the SQL script from SQL Managment studio to SSIS OLE DB Source Editor

Posted on 2016-07-20
4
44 Views
Last Modified: 2016-07-21
Hi,

As per the 'Title', please let me know how we retain same script format when we copy a SQL script from SSMS to SSIS OLE DB Source Editor.

Thanks.
0
Comment
Question by:ken hanse
4 Comments
 
LVL 51

Assisted Solution

by:Ryan Chong
Ryan Chong earned 125 total points
ID: 41722074
the format shouldn't be changed... if you not sure of this, you can try copy the scripts from SSMS to a notepad and then from notepad copy it to SSIS OLE DB Source Editor
0
 
LVL 7

Assisted Solution

by:Dung Dinh
Dung Dinh earned 125 total points
ID: 41722113
I think it is same and don't need to change anything :)
0
 
LVL 13

Accepted Solution

by:
Nakul Vachhrajani earned 250 total points
ID: 41722176
What is the issue that you are facing? Is it that the statements become misaligned? If yes, try doing this:
1. Before you copy from SSMS, select everything in the query window
2. Go to Edit -> Advanced -> Untabify Selected Lines
3. Now copy and paste to the OLE DB task in SSIS

The issue with maintaining alignments is typically that tabs are ultimately a single character and therefore occupy only a single space in some editors. One should always use spaces instead of tabs if editing is to be done in multiple environments and tools.
0
 

Author Comment

by:ken hanse
ID: 41724084
three helpful answers
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In couple weeks ago, I encountered an extremely difficult problem while deploying 2008 SSIS packages to a new environment (SQL Server 2014 standard).  My scenario is: We have one C# application that is calling 2008R2 SSIS packages to load text fi…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

827 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question