February 25, 2016 at 4:36 am
Hi All,
I am trying to deploy SSIS package on AWS RDS. Do any one have any idea how to do the same? Please get back to my post, if any one know how to do this? I need help on this.
Thanks
Ashok
February 25, 2016 at 7:19 am
Please don't cross post. http://www.sqlservercentral.com/Forums/Topic1764179-147-1.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 25, 2016 at 8:42 am
Sorry for that, but I was confused with categories available in SQL ServerCentral, as my query is regarding AWS RDS I thought of to get some response from here.
Thanks For response 🙂
March 9, 2016 at 5:03 am
Not sure which of your posts on this i should reply on however, this is covered in the AWS documentation:
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html
While Amazon RDS doesn't support some features of SQL Server, you can run SQL Server components in an Amazon EC2 instances with EBS storage, pursuant to Microsoft licensing policies. This includes components such as SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, Data Quality Services, and Master Data Services.
So what actually do you mean by deploying your SSIS package? If you want to use your RDS instance as a data source or destination that's possible, however you can't use the RDS instance to run the SSIS services. If you need a SQL instance that supports these services in AWS you will need to launch a EC2 instance with either a embedded SQL server installation in its AMI or install SQL server on your EC2 instance.
MCITP SQL 2005, MCSA SQL 2012
March 9, 2016 at 8:44 am
Hi Taylor,
First of all, thanks for response.
In RDS, we are able to get "Integration Services Catalogs" and "SQL Server Agent". Now we want to deploy our SSIS package over the network from a server (Building SSIS project) to RDS.
As we know that when we deploy a SSIS project it will be deployed in "Integration Services Catalogs". trying to do the same but when we trying to deploy, it is looking for "Windows Authentication" (of RDS) only, we are not getting "SQL Server Authentication" option to deploy the project.
Any idea on this?
Thanks in advance.
Ashok
March 9, 2016 at 9:07 am
As i quoted already from the official AWS documentation you cannot utilise SSIS in RDS SQL Server instances currently as its not supported.
One option you have is to run a EC2 instance that can execute the SSIS packages using something like dtexec rather than a full SQL instance running the packages via SQL agent jobs, the packages can still log to the catalog but you cannot deploy them to the instance.
In order to do what your asking you will have to run a full SQL server install on an EC2 instance.
This is one of the contributing factors to why we do not run SQL server in AWS and instead run MySQL RDS instances for basic database functionality and SQL server in our own data centers.
MCITP SQL 2005, MCSA SQL 2012
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply