If you google for sql server compare editions you can find the links. Here is one:http://msdn.microsoft.com/en-us/library/cc645993(v=sql.110).aspx[^]It says that developer has the same feature set as Enterprise and SSIS is on the list.

SQL

SSRS

SSAS

SSIS

Refering dlls in SSIS Script Task

10 Apr 2015 by Rajeesh Madambat

Refer and write your own business logic in C# and add it to SSIS script task.

Sql server 2008R2 SSIS weirdness when creating folder

23 Sep 2018 by CHill60

Summary of the comments which led to a solution: I first suggested checking the Precedence Constraints. My bad as the question clearly states SQL2008R2 and these didn't come along until later (2014?). However I also suggested using Sequence Containers.. which seemed to do the trick. I'll try...

SQL

SSIS

server

Email Address Validation

29 Dec 2010 by RaviRanjanKr

its always better to do all this type of validations at the FrontEnd whatever,This Link(working with Email Addresses in SQLServer)[^] may help you.

SSIS

How to intergate SSIS with Asp.Net Web application?

10 Jan 2011 by Hiren solanki

I think THIS[^] will help you.

SSIS

SSIS package: SSIS debug hot has stopped working.

10 Dec 2011 by thatraja

Fix linkMSDN - SSIS Debug Host has stopped working[^]

Convert real value to decimal value in SSIS

19 Dec 2011 by Wendelius

Could you use cast in SSIS, see: http://msdn.microsoft.com/en-us/library/ms141704(v=SQL.90).aspx[^]

SSIS

convert

Convert real value to decimal value in SSIS

19 Dec 2011 by Monjurul Habib

Try following:Conversion of decimal and date/datetime types into custom varchar equivalentsMapping of SQL Server data types to Integration Services Data Type

SSIS

convert

Data Viewers In SSIS

30 Aug 2012 by Keshav Singh

This SSIS training video will explain data viewers.

SSIS

Conditional Split Transformation In SSIS

30 Aug 2012 by Keshav Singh

This video explains conditional split transformation for SSIS.

SSIS

Ideal way of handling exceptions and purposely failing execution of C# console application

19 Jul 2013 by Sergey Alexandrovich Kryukov

In addition to the Solution 1:One ultimate requirement to handling exceptions: catch them all on the top stack frame of each thread. Event-oriented UI threads have their own twist: all exceptions should be caught in the main even cycle of the thread. Usually, UI libraries have the special...

error-handling

console

SSIS

Raw file with new line character

8 Apr 2014 by Guruprasad.K.Basavaraju

Amit,Rows are created based on the delimiter u specify in the flat file connection.In your Flat File connection manager set the row delimiter property to {CR}{LF}

SQL-Server

SQL-Server-2005

SSIS

What are sources to understand SSIS from basics to advanced?

22 May 2014 by Arjun Holla

http://www.bimonkey.com/about-the-bi-monkey/support/ssis-component-samples-list/[^]

Dynamic Column Mapping in SSIS

7 Jul 2014 by imBathini

i have SSIS package where it imports excel file to sql table that is updated weekly. I created a package where it has excel source and sql destination. It works fine but the problem here is the excel columns gets deleted /added sometimes and also the columns gets re-named. Is there any way that...

SQL

MSBI

SSIS

All About SSIS Variables - Part 2: Objects

24 Sep 2014 by derekman9707

Focus on the unique object variable data type in SSIS

SSIS

Please solve below sql query

14 Oct 2014 by OriginalGriff

Try:SELECT MonthNo, SUM(M1) AS M1, SUM(M2) AS M2, SUM M3 AS M3 FROM MyTableGROUP BY MonthNo

SQL-Server-2008R2

SSIS

What is the difference between derived column and data conversion?

26 Apr 2016 by Ruban_J

The purpose of Data conversion is to do just data conversion.While Derived column task is used for most of the transformations. To achieve this, data conversion is also put in as a part of it. If you are just intending to do data conversion and no other transform, for simplicity and...

SSIS

Free installation of SQL server SSIS

16 May 2017 by Richard Deeming

Sign up for a free Visual Studio "Dev Essentials" account: Free Developer Tools and Essentials | Visual Studio[^] That gives you access to a free copy of SQL Developer Edition, which includes SSIS.

SQL

SSIS

‘Microsoft.ace.oledb.12.0’ provider is not registered on the local machine

8 Apr 2018 by Maciej Los

Please, read this: Solved - The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine[^]

SSIS

How to intergate SSIS with Asp.Net Web application?

10 Jan 2011 by vikassoni

How to intergate SSIS with Asp.Net Web Application? How to call a package from C#? I got struck in calling properties of SSIS components.

SSIS

VS2005 SSIS package not seeing custom task assembly - that has been added to GAC

4 Feb 2011 by Randy Kroeger

1. I have created a custom package, in fact, I created a second one to make sure that the first one did not have problems. 2. Added to the GAC using gacutil 3. Tested the assemblies using a windows form as a test app.4. Opened up VS2005 and a SSIS project 5. Clicked on ChooseItems...

Save the content of a email body in outlook to a file using C#

4 Apr 2011 by WebMaster

Hi,I want to save the body content of a email in outlook to a local file. I am able to save the entire message .msg but i want to save only the html content of the body. for example: In the outlook email body i have a table i want to save that table to a file. the script which i am working...

SSIS

script

Outlook

Save the content of a email body in outlook to a file using C#

4 Apr 2011 by dbrenth

You may want to look into[Microsoft Exchange Web Services]It's much more robust than the outlook interop.Good Luck

SSIS

script

Outlook

Save the content of a email body in outlook to a file using C#

4 Apr 2011 by Wendelius

Perhaps I misunderstood your question, but when you open the mailitem, why don't you just get the data from the HTMLBody property and write that to a file for example using TextWriter class. If you use Outlook to save the message, it'll save also parts of the header etc.

SSIS

script

Outlook

Alternative for look up transformation

16 Aug 2011 by ramesh4128

Hi,Is there any alternative way for look up transformation in SSIS? Please reply me.Thanks.

SSIS

Need Help (An OLE DB error 0x80004005 (Login timeout expired) occurred while )

24 Aug 2011 by kalidass.Nandagopalan

I was tried to open VS--> New --> Project-->Integration Services Project-->add the existing ssis pacakage but i received the error like below i mention.An OLE DB error 0x80004005 (Login timeout expired) occurred while enumerating packages.Can any one help me what is the issue? .

SSIS

Can aggregate functions be used in table footer?

26 Nov 2011 by RaisKazi

Have a look at similar Question-Answer discussion below.Calculating grand totals from group totals in Reporting ServicesIts a very first link from Google-Search.Google Search Result

SSRS

SSIS

Passing Variables from C# to SSIS package

9 Dec 2011 by thatraja

Check thisHow to execute an SSIS package from .NET?[^]Some important tips passing variables to SSIS package programmatically[^]SSIS: Reading and Writing to Variables in Script Task[^]Video: Pt. 5 - How to Pass In Variables and Set Variable Values for SSIS Packages Using .NET[^]

SSIS

problem with SSIS checkpoints

24 Feb 2012 by nishantcomp2512

Hi,I an having a problem with SSIS checkpoint propery.I have a for each loop inside package and when i am executing a package with out failure means without using checkpoint then package is executes events onPreExecuteonErrorOnPostExecutebut when package restrted with check point...

SQL

SSIS

Migration Work in SQL

17 Apr 2012 by Bhoopendra Pratap Singh

Hi,You can follow given steps.1.Take a data flow Task in Control flow from tool box.2. Double click on dataflow task and add Excel source.3. Fill Excel Source with Connection which ultimately will take schema from existing excell sheet.4. Use the Data Conversion Transformation if you...

SQL-Server

SQL-Server-2005

SSIS

How to Autogenerate an numer in ssis and use in execute sql task

14 May 2012 by Maciej Los

First of all, my knowledge about SSIS is... equal zero! If you want to insert values (...)starting from 000001 and increment continuously for each row(...), it's not so simple! Why? 000001 is not a numeric value, it's a text!The below example shows how to add/insert 1K...

SSIS

"Table Lock " option in OLEDB Destination control in SSIS

7 Jun 2012 by RDBurmon

It only locks the destination tableYes, you can insert and read data into and from the source table - the source data will only have a lock on it when the select query is executing.Hope this helps , If yes then plz accept and vote the answer. Any queries / questions on this are...

SSIS

use datawarehouse against multiple identical database

21 Jun 2012 by db7uk

I think you are going to need views that return the data you want but are called the same in all database. To help organisation you should put the views in a schema other than dbo.The only problem with this is crud operations. Are you planning to update the tables?

SQL-Server

SSIS

Remove the duplicate values from the flat file source using SSIS

29 Jun 2012 by Herman<T>.Instance

What you can do is after import copy the data to another table that has an identifier field.With the next statement you can determine the doubles and know by the unique ID that you can delete the doublesafter that you can set them into the table that needs the dataselect uniqueID,...

SQL

SQL-Server

SSIS

Import multiple Microsoft Project 2010 .MPP files into SQL Server 2008 R2 with SSIS

22 Jul 2012 by woutercx

If you would be able to save the project files as XML format (I see that .mpp is binary), that would be a whole lot easier.. You could call the SaveAs function from VBA. Here's an example I think.http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/f1895801-5b2b-4aba-be41-d529f796ae87[^]

Excel Data Upload Through SSIS

10 Aug 2012 by bhaveshbarot2004_05

Yes. Resolved.Please refer part I & II of below video.http://www.youtube.com/watch?v=CFWY4rCqEZQ[^]http://www.youtube.com/watch?v=_B83CPqX-N4[^]Thank you.

SSIS

Fetching Progress tab result in text file in SSIS.

16 Aug 2012 by Member 9362521

Hello,In my project I have to fetch the progress tab/ Execution result tab detail into text file.I could not use tablea for the logging.Can anyone tell how i can do this?please give me your suggestion.

SSIS to write different worksheets of one workbook as per output from stored procedure

20 Aug 2012 by Kuthuparakkal

1. First Create a variable "ProductList" as Object Type.2. Create a string variable "ProductName"3. Get SQL Task that produces Distinct List of products that you would like to pass to SP. And assign the task result set of Full Row Set to "ProductList" variable4. Get For Each Loop with...

SQL-Server

SQL-Server-2005

SSIS

SSIS 2008 packages deployment error on 64 bit machine

26 Sep 2012 by Kuthuparakkal

Yes, it's the 64 bit compatibility of ACE OLEDB drivers. You have two options.1. Force the package execution to 32 bit mode.2. Install latest ACE OLEDB drivers:http://www.microsoft.com/en-us/download/details.aspx?id=13255[^]If yo are using SQL Agent Job to run/schedule package,...

SSIS

Executing SSIS package on client machine

9 Oct 2012 by Kuthuparakkal

You need not have to install SQL Server until and unless you need a database. But you definitely need Integration Services installed to execute SSIS package.Follow: http://msdn.microsoft.com/en-us/library/ms143731(v=sql.105).aspx[^]

SSIS

Dynamically creating an excel using SSIS

16 Dec 2012 by Kuthuparakkal

Firstly, SSIS works on predefined mapping. So any dynamic column header will produce run time error.I would suggest create a template and store it somewhere. Then your package copy(script task will do) to report generation location. Se the connection to the new file copied. Let the data flow...

SQL

SQL-Server

SSIS

Compress Dynamic Files Using 7-Zip in SSIS

13 Feb 2013 by Sifiso W Ndlovu

How to compress dynamic files using 7-zip in SSIS

SSIS

SSIS SQL Task Executing on first day of Every Quarter

18 Mar 2013 by Kuthuparakkal

The best way is to use SQL Server Job Agent, you get flexibility of scheduling job at any time. But if you are particular about SSIS and Execute SQL Task, then you may use this:DECLARE @CanExecute INTSET @CanExecute = CASE WHEN ...

SSIS

Dynamic connection for source and destination

20 Mar 2013 by ZurdoDev

Go ahead and create the connections to whatever you have currently. Then select your connection in the Connection Managers window. Click Expressions in the Properties window and then set your ConnectionString to be something like "Provider=SQLOLEDB.1;Data Source=" + @[User::arg_srvr] +...

SSIS

Hosting and sheduling SSIS project

16 Apr 2013 by Kamalkant(kk)

In SQL Server Management Studio, highlight SQL Server Agent -> Start. Highlight Job ->New Job…, name it , myJob.Under Steps, New Step, name it, Step1,Type: SQL Server Integration Service PackageRun as: myProxyPackage source: File SystemBrowse to select your package file xxx.dtsxClick...

SSIS

Providing environment variables to package execution using PackageInfo class

15 May 2013 by Vic91

I finally solved this! The problem was that I was trying to set the parameter values individually, when actually these where defined project-wise. All I had to do was give the execution an EnvironmentReference object and voilà! These are the assembly references:using...

.NET

SQL-Server

SSIS

unable to import using System.Linq; namespace in ssis scriptask (2008)

24 May 2013 by Raju9959

Im tying to use [using System.Linq;] namespace in ssis 2008 scrip task when im type it manually it shows error such asError 1 The type or namespace name 'Linq' does not exist in the namespace 'System' (are you missing an assembly reference?)

SQL

SSIS

SSIS Tip 1: Using "Select Query" to define source

10 Jul 2013 by ThatsAlok

Using coding define SSIS source connection.

SSIS

Ideal way of handling exceptions and purposely failing execution of C# console application

19 Jul 2013 by Ron Beyer

I would fail with a generic error then write detailed failure info to the application log or an error reporting file. Best practice for handling exceptions is to only handle exceptions that you can do something about it, the rest you pass up the call stack (aka, don't catch them). You can...

error-handling

console

SSIS

email ssis error code if job fails at step

2 Sep 2013 by TheUltimateDebugger

ssis-send-mail-for-errors[^]Let-ssis-notify-you-of-its-own-errors.html[^]

SSIS

Watching shared folder through WMI Event Watcher Task

12 Nov 2013 by agent_kruger

use the below codeFileSystemWatcher watcher = new FileSystemWatcher() { Path = FilePath, Filter = "Refresh.txt" }; watcher.EnableRaisingEvents = true; watcher.Created += new...

iteration in vb.net to get files

17 Dec 2013 by Maciej Los

Please, read my comment first.Here is an idea: Foreach Loop Container[^]TN wrote:SQL Server Integration Services provides the following enumerator types:...Foreach File enumerator to enumerate files in a folder. The enumerator can traverse subfolders. For example, you can read all...

SQL-Server

SSIS

Commit in SSIS after each file process

19 Dec 2013 by Maciej Los

Truly? I have no idea, because you did not specify what have you done till now.Have a look here: Foreach Loop Container[^]

SQL-Server-2008

SQL-Server

SSIS

[Not a question] Code to download files from ftp server to local disk

20 Dec 2013 by Sergey Alexandrovich Kryukov

You can use the class System.Net.FtpWebRequest: http://msdn.microsoft.com/en-us/library/system.net.ftpwebrequest%28v=vs.110%29.aspx[^].You can also use the class System.Net.WebClient, which provides simplified functionality, and the required protocol is determined by the...

SSIS

How to add rowcount Variable in SSIS log table

9 Jan 2014 by MAbubakar.Riaz

hi i only need three thingspackage start time,package ending time andnumbers of rows generated,package start and end time was recorded by jst enabling logging with SSIS Log Provider for SQL Server and in details events; i selected nothing.now i want to add column or row that...

SSIS how to format DMY format into YDM

3 May 2014 by Andrius Leonavicius

Hi,I am not sure what exactly you mean by saying "to put the date into a '2014/05/03'"...In SQL Server, date values are stored in an internal format, not something like "DD/MM/YY", "YYYY/MM/DD", etc. But there are rules for how different datetime formats are interpreted. If you'd like to...

SQL

SSIS

I want to study ssas,ssis,ssrs before what are things we should known in sql and tell me the tutorial and practice sites to learn

24 May 2014 by Maciej Los

Please, read Was Aday's comment to your question. You should try to find anything using Google[^] or SearchBox[^] on the right-top corner of this site.Here is a collection of useful links:Analysis Services Tutorials (SSAS)[^]SSIS Tutorial: Creating a Simple ETL Package[^]SQL Server...

SSIS Help with Magento database

28 May 2014 by Rush3rd

Trying desperately to work out code to transform data from simple SQL database to very complex Magento mySQL format. Any experts in transforming data that could help me work out a complex loop?

SSIS

How to deploy SSIS package with protection level "EncryptAllWithPassword" to MSDB?

5 Aug 2014 by coded007

we need to run SSISdeployment manifest. referenceshttp://social.msdn.microsoft.com/Forums/sqlserver/en-US/b2aba4d0-91fd-4258-aadb-41860aabef17/deploying-a-ssis-package-with-the-protection-level-to-encryptsensitivewithpassword?forum=sqlintegrationservices[^]

SQL

SSIS

SSIS - Import Text File

16 Sep 2014 by Math08avan

SQL Server Integration Services - How to read a text file

All About SSIS Variables Part 3 Variable Assignment

26 Sep 2014 by derekman9707

This post discusses about variable value assignment in SSIS.

SQL

SSIS

How to Search for an Excel File in a Folder using the SSIS Script Component and a Regular Expression

4 Dec 2014 by Bertin @nonodata.com

Search for an Excel file in a directory, rename the worksheet, then import the data in a database

.NET

Dev

SSIS

Is InfoPath Forms really secure

10 Jan 2015 by Kornfeld Eliyahu Peter

Both InfoPath and ASP.NET application as secure as you made it!If it done wrong you got a big hole in your system with both, so there is no difference between them in that...If you want to convince your boss that the InfoPath solution isn't secure first learn how it can be secured, than find...

Is InfoPath Forms really secure

10 Jan 2015 by Manas Bhardwaj

None of them are secure or not-secure on their own. It depends on how you implement a particular functionality using these technologies. On the other hand, if you are really building new applications with InfoPath then I would suggest you to rather think about continuity and eventually an...

how to show package progress

15 May 2015 by virusstorm

This is a very basic solution, but it should give you a good starting point.var commandText = "SELECT * FROM dbo.PackageLog";var connectionString = ConfigurationManager.ConnectionStrings["localDatabse"].ConnectionString;DataTable dataTable = new DataTable();using (SqlConnection...

C#5.0

.NET

SSIS

Difference between Fast Parse and Bulk insert

22 May 2015 by Simon_Whale

Fast Parse[^] is as it says is a method to parse the dataBulk insert[^] is an efficient way to copy large amounts of data into a table or view

SSIS

Problem in reading Flat file as data in one column have Comma ","

17 Jun 2015 by F-ES Sitecore

Whatever generates the CSV file needs to wrap the fields in quotes"field 1", "field 2", "this, that"then your code needs to treat only commas outside of quote pairs as being the separators so that it knows "this, that" is a single field and not two. There are various libraries out there...

SSIS

how to get the last row in file as row count but all other columns to be NULL?

27 Oct 2015 by Suvendu Shekhar Giri

You can do something like -SELECT A,B,C,CASE WHEN ROW_NUMBER() OVER(ORDER BY A,B,C)=(SELECT COUNT(*) FROM dbo.YourTable) THEN (SELECT COUNT(*) FROM dbo.YourTable) ELSE NULL END AS RowCntFROM dbo.YourTableIf this doesn't help, please share the sql you have tried so far...

SSIS

How can I make this T-SQL with an expression SSIS ?

3 Nov 2015 by Suvendu Shekhar Giri

Searhed this in google and found that one way is to do this using DATEPART()Check this link-SSIS Date in derived column as yyyy-mm-dd format[^]Hope, it helps :)

SSIS

Attunity Connectors to Transfer Data from Oracle to SQL Server using SSIS

7 Dec 2015 by Divyant Kulshrestha

This tip is useful when we have to move data from Oracle database to SQL Server database or vice-versa using SSIS.

SSIS 2012 data extract from MS ACCESS 2007 database

21 Jan 2016 by Brian Lace

looks like a file system permission issue

SQL

connectionstring

SSIS

Dynamic Mail Attachment in SSIS

31 Jan 2016 by RDBurmon

below steps would work - 1) To Create dynamic excel sheet and export data from SQL SSIS Package: Export Data from Database, Daily to New Excel Without Using Script Task[^]2) To modify variable "DestPath" (as mentioned in above blog) to generate the file name including...

SQL

SSIS

How to keep the structure of the tablix when there is no data to show

24 Feb 2016 by CHill60

The IsNothing function will only work if a row has been returned. Your problem is that there is nothing to return (and therefore nothing for the function to work on).You could use a stored procedure that does something like IF EXISTS (select * from table3) SELECT id, datum FROM...

Passing paramters to SSIS package

5 Apr 2016 by CHill60

This is not a case of resolving an issue, more pointing you in the right direction for your research.These will be good starting points:Passing Values into an SSIS Package at Runtime from Outside the Package - SQLServerCentral[^]sql server 2008 - Executing the same SSIS Package with...

SSIS

The specified string is not in the form required for an e-mail address

12 Feb 2017 by OriginalGriff

It's going to be data dependant - that code looks a lot like mine which works fine - so you need to use the debugger and look at exactly what is happening, and in particular what your ChangeSeprators method is getting as an input and returning. Since to and cc require valid emails (not just the...

SSIS

How to achieve RESEED concept on uniqueidentifier field

24 Mar 2017 by Richard Deeming

RESEED only applies to IDENTITY columns.Based on the code you've posted, table 2 does not have an IDENTITY column. Therefore, you cannot use RESEED with that table.

SQL

SSIS

Loop through database in SSIS script transformation

7 May 2017 by CHill60

The reason that only the last row from the database is written to the file, is because you are recreating the file each time you call this Input0_ProcessInputRow method. You need to create and close the file outside of the loop Do something like this instead: public void...

SQL

SSIS

Can anyone help me convert this VB code to C#?

5 Oct 2017 by OriginalGriff

That's VBA code - C# doesn't use DAO objects, it uses SqlConnection, SqlCommand, SqlDataAdapter, and their ODBC equivalents, among others. There is no direct translation of that code to SQL: there is no RecordSet in .NET Instead, you will need to rewrite it for .NET, using .NET classes. Or...

SQL

SSIS

MS-Access

Script component transformation SSIS

7 Dec 2017 by CHill60

Take great care over how you indent your code and errors will sometimes leap out at you. For example look at the segment...} { if (Row.Column0 == b) { BatchHeaderBuffer.AddRow(); } - That random open brace { on a line by...

SQL

SSIS

How to insert more than 255 columns into oledb SQL server destination using excel source version 2007

16 Dec 2017 by Jörgen Andersson

There is a 255 column limitation in the JET driver for Excel. Try adding the range to the query. SELECT * FROM [Sheet1$A1:EH65535]

SQL

MS-Excel

SSIS

How do I write a merge query deletion of records

19 Feb 2018 by Member 13685473

Hi Friends, I have an issue while loading data through SSIS through CSV files and writing Merge Query. I have a table Name [REVENUE_ADJUST_TRX] and it has a composite key which is [HEADER_TRX_LINE_ID] & [TRX_NUM]. The Problem statement is i have to load Incremental data but while loading...

SQL

mergesort

SSIS

Communication protocol error

4 Jun 2018 by Shiva Kumar

When i'm trying to get the response from soap service i'm getting the following error. The header 'ReliableMessaging' from the namespace 'http://sap.com/xi/XI/Message/30' was not understood by the recipient of this message, causing the message to not be processed. This error typically...

Sql server 2008R2 SSIS weirdness when creating folder

23 Sep 2018 by #realJSOP

I have a package with the following tasks: File System task - Create a folder if it doesn't already exist. File System task - Delete file if it exists in the folder FTP task - copies new file and places it in the folder. I'm using variables to determine the path name form parameters passed...

SQL

SSIS

server

About ssis documentation

28 Jan 2019 by MadMyche

Well, I have received no documentation on using either. I use existing reports/packages, coworkers, and google when I have questions. I document all of the projects I work on, and take notes on code/syntax that doesn't exactly make sense.

SSIS

How to change cell color based on column and row indexes in dataset ?

6 Feb 2019 by Maciej Los

What you are trying to attempt in this line: dsDataCell.Tables[Data_Sheet].Rows[RowIndex][ColumnIndex] = Color.Red; is to change a value in a cell of "Data_Sheet" DataTable, which is impossible! Note: Color.Red returns a system-defined color that has an ARGB value of #FFFF0000 You should...

SSIS

How to get latest folder details dynamically in ssis

6 May 2019 by #realJSOP

Use a (C#) script task to get the folder names and convert them to datetime objects using the DateTime.TryParseExact method. When you find the "latest" one, set a package variable to the folder name.

SSIS

How to conduct unit testing in SQL server integration services using visual studio (ssdt)

9 Mar 2020 by #realJSOP

You could load the excel file and the database table's schema into separate ADO datatables, and then compare the schemas between the datatables. Depending on how extensive your data type discovery is during the import process, you could also...

How to trigger SSIS package on post-creation of record in ms dynamics crm on-premises and online verison

5 May 2020 by MadMyche

Have you thought about running a Google Search for MS Dynamics trigger SSIS[^]? The first result does look a pretty good walk through of the process and it looks like it could be almost exactly what you are looking for: Integrating CRM using SQL...

SSIS

Sybase client version 16 missing sybase provider

20 May 2020 by Member 14838967

Hi, I have been using the older version(i think its 14.x) of Sybase client before, and the project runs without problem using Native OLE DB\Sybase OLEDB Provider with the OLE DB Provider as Sybase OLEDB Provider. However, after upgrading to...

Visual-Studio

SSIS

Sub-query which returns several lines

29 May 2020 by #realJSOP

Dude, learn how to format your code so we can read it. Beyond that, here is your code formatted. Note the comments: SELECT Q.DTNUMEXE ,Q.DTMOIEXE ,Q.DTANNQIT ,Q.DTMOIQIT ,Q.DTCODBRC ,Q.DTSERQIT ...

How to remove multiple characters between 2 special characters in a column in SSIS/SQL

12 Jan 2021 by Maciej Los

How about: STRING_SPLIT[^] and STRING_AGG[^] They are MS SQL Server specific. If your database provider is different than MS SQL Server, you forgot to mention that in your question. Usage: CREATE TABLE testNames ( LongName varchar(1000) ); ...

How to remove multiple characters between 2 special characters in a column in SSIS regular expression

14 Jan 2021 by Richard MacCutchan

You already posted this question at How to remove multiple characters between 2 special characters in a column in SSIS/SQL[^] and received an answer. Please do not repost.

T-SQL

SQL

SSIS