SSIS: Import and Export text file

• outdoor001.forum

  Grasshopper

  Points: 14

  More actions

  April 11, 2015 at 10:42 am

  #398310

  Hi Any Body,

  I am new on developing SSIS and I very need your help or opinion guys! 😀

  I have a SSIS to get a manually input user's from a text file into User's database. However, I have hard time doing the following steps below.

  1. My SSIS imported a textfile with sample name "Users.txt" and inserted the data into a User's table

  Users.txt - with data User1, User2, User3 will be insert into USERTABLE

  After the text file data inserted to the USERTABLE, this table has now the following values below

  User1

  User2

  User3

  2. After saving into the database/USERTABLE, the SSIS should search(maybe we could use syslogins query) if User1, User2, or User3 are exist against all "Registered Servers"

  If a certain user exist eg. User1 and User2

  SSIS will get the detail wherein User1 and User2 exist

  with ServerName, LoginName, and Policy and this will be exported into text file

  Question:

  1. How can I check User1 and User2 from Users.txt against all my "Registered Servers"

  2. How I export the ServerName, LoginName and Policy into a text file?